Page 1 of 1

Improve a delete from database

Posted: Fri Jun 04, 2010 3:38 am
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());


Re: Improve a delete from database

Posted: Fri Jun 04, 2010 3:44 am
by markusn00b
The MySQL documentation shows you the syntax for multi-table DELETEs.

Re: Improve a delete from database

Posted: Fri Jun 04, 2010 4:51 am
by tito85
Thanks for the info. I will check it out.