SQL SELECT WHERE THIS "OR" THIS - why isnt this code working?

$SQL = "SELECT * from TABLE WHERE USERNAME = '$a' AND STATUS = 'Active' || STATUS = 'Cancelled'";

So this works if STATUS = Active or if STATUS = Cancelled - no problem

$SQL = "SELECT * from $t_ WHERE $u_ = '$a' AND STATUS = 'Active' || STATUS = 'Cancelled' || STATUS = '$nil'";

This stops Active and Cancelled from working and instead only $nil works...

Why is that?

Thanks
-Arron

ORs are very touchy and often produce results surprising to the programmer. Or at least to this programmer.

I find that parens are helpful, also INs, in constructing these sorts of queries.

WHERE $u_ = '$a'
AND (STATUS = 'Active' OR STATUS = 'Cancelled' OR STATUS = '$nil')

Alternatively:
WHERE $u_ = '$a'
AND STATUS IN ( 'Active', 'Cancelled', '$nil')

The second method is foolproof.

Sonovagun.. the paren's did the trick. Sir you just saved this weary programmer from a nervous meltdown. Hehe. Thankyou!

Don't forget to mark this thread resolved.