ShoeLace1291 Posted November 16, 2008 Share Posted November 16, 2008 I'm trying to gather row information but I have multiple WHERE, AND, and OR options. I have several different table fields that need to match the query. ladderID challengerID opponentID reported Any row selected must have either the challengerID equal the clan being viewed and vice versa for opponentID. reported must also equal 0 and the ladderID must be equal to whatever ladder is being viewed. this is my current query. SELECT * FROM matches WHERE challengerID = '".$thisclan."' OR opponentID = '".$thisclan."' AND reported = 1 AND ladderID = '".$ladderID."' It is currently not working because I inserted a new row with the ladderID = 2 but it still shows up when you view ladder 1. Quote Link to comment https://forums.phpfreaks.com/topic/132981-select-query/ Share on other sites More sharing options...
fenway Posted November 17, 2008 Share Posted November 17, 2008 Order of operations... use parens whenever you mix ORs and ANDs: SELECT * FROM matches WHERE ( challengerID = '".$thisclan."' OR opponentID = '".$thisclan."' ) AND reported = 1 AND ladderID = '".$ladderID."' Quote Link to comment https://forums.phpfreaks.com/topic/132981-select-query/#findComment-692165 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.