[RESOLVED] mysql delete

[slick101]

Hey im trying to do something like this; need to delete 2 rows.

$q = "DELETE FROM info WHERE (id = 98 AND uid = 97) AND (id = 97 AND uid = 98)";
$rs = mysql_query($q);

I get empty results but there are 2 rows.

is this possible or must it be 2 queries?

[etully]

DELETE FROM info WHERE (id = 98 AND uid = 97) OR (id = 97 AND uid = 98)

The way you had it written required that the id be both 97 and 98 at the same time which is impossible in this universe. 🙂

[slick101]

etully;10912329 wrote:

DELETE FROM info WHERE (id = 98 AND uid = 97) OR (id = 97 AND uid = 98)

The way you had it written required that the id be both 97 and 98 at the same time which is impossible in this universe. 🙂

haha yes that was it, i just thought about it. thanks for the response.