MYSQL SEARCH WHERE question (should be easy answer)

[bateati]

I'm trying to search the 'ad' column where 'ad' = 1 or 3

 

I'm having problems doing this.

 

Here is what I currently have, but it is not bringing back 'ad' where ='1' (for obvious reasons)

    $query = "SELECT * FROM users WHERE ad='3' AND state='$state1'";

 

Here is what I thought would work, but it displays every listing in my database when I do it this way.

 

    $query = "SELECT * FROM users WHERE ad='3' OR ad='1' AND state='$state1'";

 

 

Thank you in advance for your answers, google is not being so kind to me right now.

[MasterACE14]

both queries are fine. If you want to 'limit' the results add "LIMIT 25" or whatever number to the end of the query.

[BigTime]

Hi bateati

 

try WHERE (ad='1' OR ad='3')