jason360 Posted March 2, 2015 Share Posted March 2, 2015 Hey guys, I am not sure how to phrase this WHERE statement. I currently have this: WHERE approved = "1" AND item_gender="1" OR item_gender="3" It seems to be omitting the 'approved' part. What I require is that approved=1 must be adhered to regardless, but item_gender can be equal to 1 or 3. Any ideas what I am doing wrong? Thanks! Link to comment https://forums.phpfreaks.com/topic/295002-sql-where-statement/ Share on other sites More sharing options...
Barand Posted March 2, 2015 Share Posted March 2, 2015 Use (..) to ensure the logic you really want WHERE approved = "1" AND (item_gender="1" OR item_gender="3") otherwise the logic defaults to WHERE (approved = "1" AND item_gender="1") OR item_gender="3" Alternatively, use IN instead of multiple ORs WHERE approved = "1" AND item_gender IN (1, 3) Link to comment https://forums.phpfreaks.com/topic/295002-sql-where-statement/#findComment-1507201 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.