Hi, I want to know could a sql Where clause use more then one field?
let me explain. I want to do something like this:
I want to know if I can use more then one condition in the where clause and if so how do I seperate each condition?Code:SQL -> ("SELECT * FROM places WHERE country = $country , state = $state , city = $city catagory = $catagory");
do I just use , or use . . inbetween the conditions then followed after by a , ?
my goal here is to query search postings made by users for only their country,state/region,city, and the catagory. Like what the postings about.
I want to use those values to grab only matching values from the database and display them.
So how would I do this correctly. what do I need to use to seperate each filed = too values...
Thanks you for your time.