SELECT Query

[ShoeLace1291]

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.

 

 

[fenway]

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."'