[RESOLVED] And Or Problem

[neroag]

Hi All
Is there a way in a $query to search for a $var OR $anothervar ie....

$query="SELECT * FROM hcs WHERE Client='$sclient' And Status='$sstatus' OR Status='$sstatus2' ";

many thanx guys

[bough]

if you mean either where the condition Client='$sclient' And Status or condition Status='$sstatus' is met, you can just simply add brackets to your sql ie

$query="SELECT * FROM hcs WHERE (Client='$sclient' And Status='$sstatus' ) OR Status='$sstatus2'

[Plasma]

Alternativly use the IN Statement:

SELECT * FROM hcs WHERE Client = '$sclient' AND Status IN ('$sstatus', '$status2')... etc

[bough]

ah yes i think i got what conditions you wanted wrong, so my brackets may be in the wrong place

if you walways want to match the condition and either of the status conditions then using the "IN" is good way to do it. It depends on what conditions you want to match

[Roger_Ramjet]

You need to know the operator precedence for mysql. OR takes precedence over AND so your original query would evaluate to true if only the Status='$sstatus2' were true, whatever the state of Client='$sclient' . This is the main mistake that people make when using OR.

[neroag]

Thanks guys

this seems still to be just testing $sstatus

$query="SELECT * FROM hcs WHERE Client = '$sclient' AND Status IN('$sstatus', '$sstatus2')";

i have a table where the word "Live"" or the word "Open" might be in the row named status, when running the query i need it to test row named status for either of those words & where the row named Client="$sclient"

thanx again

[Roger_Ramjet]

So echo the query before you run it and you'll spot the syntax error I'm sure.

[neroag]

Couldnt see a syntax error in the $query line itself, but the echo did reveal that the $sstatus2 variable wasnt being set properly so thanx Roger, & of course everyone else