[Resolved] SQL Query

$query_items = "SELECT * FROM games WHERE one='".$clanref."' OR two='".$clanref."' AND status='challenge' ORDER by tableid";

I have been using this sql query but it seems to be ignoring everything from AND onwards... any ideas?

I don't know if it would work but you could try to put ... OR ... into brackets:

$query_items = "SELECT * FROM games WHERE (one='".$clanref."' OR two='".$clanref."') AND status='challenge' ORDER by tableid";

It might be that it treated your conditions like ... OR (... AND...)

worked, thanks