Hey im having a bit of trouble with an sql statement, iv got a table of user details i want the users to be able to see a list of members who match certain criteria.
iv got
$sql = "Select `displayname`,`category`,`sex`,`orientation`,`status`,`location`,`highSchool`,`occupation` FROM profile_quickfacts
where category= '$Category'";
what a want is to be able to use multiple criteia like
$sql = "Select `displayname`,`category`,`sex`,`orientation`,`status`,`location`,`highSchool`,`occupation` FROM profile_quickfacts
where category= '$Category'
where status= '$status'";
but im not sure how to do this iv tried things like ',' but im quite new and im not sure what it could be
thanks for any info or links
cheers🙂
