使用2个表中的一个查询删除记录时出现问题

Question

When I try this directly in phpMyAdmin:

DELETE FROM navigation WHERE id='14';DELETE FROM subnavigation WHERE navi_id='14';

It works but when I it doesnt work with my PHP query that I make:

$db->query('DELETE FROM navigation WHERE id='.$id.';DELETE FROM subnavigation WHERE navi_id='.$id.';');

It gives me this error and doesnt delete anything:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM subnavigation WHERE navi_id=14' at line 1

I think that I am missing something really small! Thank you for your time and help.

Answer 1

Make it one query.

//don't forget to protect yourself from SQL-injection attacks!
$id = mysql_real_escape_string($id);

$delete_query = " DELETE n, sn from navigation n
                  LEFT JOIN subnavigation sn ON (n.id = sn.id)
                  WHERE n.id = '$id' ");
$db->query($delete_query);