why won' this work?

[zak]

i'm using mysql and i want to delete a row from two tables where the id equals a specified number. here's what i tried using:

$db_query = ("DELETE FROM $db, $db_info WHERE $db.id = '$HTTP_GET_VARS[id]' AND $db_info.id = '$HTTP_GET_VARS[id]';");

i have set the values of $db and $db_info in the script and checked them to see that they are correct.

I get this message with mysql_error():

You have an error in your SQL syntax near ' ww1soldierinfo WHERE ww1soldiers.id = '1' AND ww1soldierinfo.id = '1'' at line 1

Thanks in advance for your help.

P.S. b4 i get flamed, i know $HTTP_GET_VARS is deprecated!

[Lars_Berg]

You can only delete from one table with one statement. Use two delete statements within a transaction.

[trooper]

The above suggestion will work fine if .....

your table type is a table type that supports transactions (BDB Innodb etc

HTH

GM