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());