[RESOLVED] Simple mysql syntax help

[Megahertza]

This is what i'm trying. And you can guess what i'm trying to do. Is this the correct way of doing it or can it not be done.

$pm_query = mysql_query("SELECT * FROM messages WHERE username = '$username' AND status = 'read' or 'unread'")

[Megahertza]

Solved my own prob with guessing. Correct systax is.

$pm_query = mysql_query("SELECT * FROM messages WHERE username = '$username' AND status = 'read' or status = 'unread'")

[herve]

Don't forget the () around the conditions, otherwise you rely on operator's priority
which can be tricky on more complex conditions.

Is it "WHERE A and B or C" read as " A and (B or C) " or read as "(A and 😎 or C" ?
which of course is not the same condition.

To avoid any ambiguity you can use :

SELECT * FROM messages WHERE (username = '$username') AND ( ('status = 'read') OR (status = 'unread') )

[Megahertza]

Thanks dude, should help if my site gets to any size.