[RESOLVED] MySQL Query with two AND clauses seperated by an OR

[Napster]

Say I had a table of private messages named 'messages' with the fields, 'id', 'to', 'from', 'message' and 'dateline'. How would I construct a mySQL query that selects all rows where to is from user x and from is from user y OR to is from user y and from is from user x.

This code did not work as I tried that first

$QUERY = mysql_query("SELECT * FROM op_messages WHERE (to = '1' AND from = '6') OR (from = '6' AND to = '1') ORDER BY dateline DESC") or die (mysql_error());

Thanks.

[NogDog]

Does that code generate an error? If so, what is the error message?

My guess is that MySQL may not be crazy about the column name "from", and possibly also "to" though I'm not sure about that. In any case, you can avoid any confusion with column names and reserved words by quoting the column names with "back ticks":

. . . WHERE (`to` = 1 AND `from` = 6) . . .

[Napster]

The Backticks worked. Thanks.