Improve a delete from database

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
tito85
Forum Contributor
Posts: 104
Joined: Sat Mar 13, 2010 11:26 am

Improve a delete from database

Post by tito85 »

Hi,

Can the follow be done by using a single query to delete all?

Code: Select all


 $delete1 = "DELETE FROM movies WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete1) or die(mysql_error());
	  $delete2 = "DELETE FROM genres WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete2) or die(mysql_error());
	  $delete3 = "DELETE FROM directors WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete3) or die(mysql_error());
	  $delete4 = "DELETE FROM comments WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete4) or die(mysql_error());
	  $delete5 = "DELETE FROM favorites WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete5) or die(mysql_error());
	  $delete6 = "DELETE FROM ratings WHERE MovieID = '" . $_GET['id'] . "'";
      mysql_query($delete6) or die(mysql_error());

User avatar
markusn00b
Forum Contributor
Posts: 298
Joined: Sat Oct 20, 2007 2:16 pm
Location: York, England

Re: Improve a delete from database

Post by markusn00b »

The MySQL documentation shows you the syntax for multi-table DELETEs.
tito85
Forum Contributor
Posts: 104
Joined: Sat Mar 13, 2010 11:26 am

Re: Improve a delete from database

Post by tito85 »

Thanks for the info. I will check it out.
Post Reply