problem with sql statement

[gabrielkolbe]

Hi i would be grateful if someone can help me here...

This script has to delete info from 4 different tables, the tables all have the same ID called prop_ID. but i get this sql error.

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 'WHERE a.prop_ID = '210' AND b.prop_ID ='210' AND c.prop_ID = '210' AND d.prop_ID' at line 2

here is the php code:

$prop_ID = $_GET['prop_ID'];
if (isset($_POST['submit']))
{
     $query_delete = "DELETE FROM right_prop_1 a, right_prop_2 b, right_prop_3 c, right_prop_4 d
	 WHERE a.prop_ID ='$prop_ID' AND b.prop_ID ='$prop_ID' AND c.prop_ID ='$prop_ID' AND d.prop_ID ='$prop_ID'";
     $result_delete = mysql_query($query_delete) or die(mysql_error());

 header ("location: my_properties.php"); 
 }
else
{

[stew]

not too sure, but it think you need to do four separate sql statements...

[toplay]

stew, that's ok as is if one has MySQL version 4.0 or higher.

The syntax you're trying to use requires a 'USING' keyword and v4.0.2+. See manual page:

http://dev.mysql.com/doc/mysql/en/delete.html

hth.

[stew]

well it just goes to show... that you do learn something new everyday!