MYSQL help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
DanHardy
Forum Newbie
Posts: 3
Joined: Thu Mar 25, 2010 9:25 am

MYSQL help

Post by DanHardy »

Hi all,

I have the following mysql delete query that essentially deletes a row from two seperate tables "messages" and "messages2" where the id is equal to that in both of the tables. The problem I am getting (for obvious reasons) is that it will only delete from the table, if it indeed exists in both tables.

Here is the query:

Code: Select all

DELETE FROM messages,messages2 USING messages,messages2 WHERE messages.id = messages2.id AND messages.id = ?;
How would I go about setting it so that the query always deletes from table "messages" and only deletes from "messages2" when a corresponding id exists?

I think it would involve an IF EXISTS clause, but I am not sure on this, or indeed how to implement it.

Thanks in advance guys

Dan
Post Reply