Deleting from Multiple tables??

jacquesy

I want to delete recordfs from multiple tables where the id matches but have been unable to work out how to do this??

The MYSql version on my remote server does not support this so I need to do in in two queries but I cannot get this working, it goes through OK but when I check my database it actually hasnt been removed?

//insert manufacturer values into database
$Query = "DELETE from manufacturer where dbManufacturerId = '$man_id'";
$Query = "DELETE from model where dbManufacturerId = '$man_id'";

what do I need to change to make the 2 queries work together?

Thanks for your help!

lush_pierre

You can simply delimit the queries with a semicolon:
$Query = "DELETE from manufacturer where dbManufacturerId = '$man_id'; DELETE from model where dbManufacturerId = '$man_id'";

Any action query can be delimited like this as it returns no results. This is a perfectly acceptable way of deleting from multiple tables.

If this still isnt working, are you sure you have the necessary permissions for 'delete' queries?

Pete.

jacquesy

I have tried this and it doesn't work but when I try it locally it is fine, is there a conflict in the versions of mysql?

Is there any other way I can perform both queries?

Thanks

lush_pierre

I am a bit unclear as to what you are having trouble with....

Can you perform a single delete remotely? Is it only the double delete that you cannot achieve?

Is it really necessary for you to do it in 1 step, wouldn't 2 suffice?

If you are worried about inconsistencies in mysql - get in touch with your webserver and find out the version numbers and check them out on the web. However, this is simple sql and i see no reason why it shouldn't work.