delete from multiple tables at once?

[blueman378]

hi guys i was wondering would a guery like this work:

$query  = "DELETE * FROM users,contacts,project WHERE id='$_SESSION[userid]' ";
$result = mysql_query($query);

 

thanks

[haku]

http://www.haughin.com/2007/11/01/mysql-delete-across-multiple-tables-using-join/

[blueman378]

yeah... im not exactly the best with joins,

 

can someone please give me a example of how to delete * from the three tables where id = 1

 

(id is a consistant

column on all 3 tables)

 

cheers

[Jabop]

$query  = "DELETE * FROM users,contacts,project WHERE id='$_SESSION[userid]' ";
$result = mysql_query($query);

 

$query = "DELETE * FROM users WHERE ID='$_SESSION[userid]'";
$query = "DELETE * FROM contacts WHERE ID='$_SESSION[userid]'";
$query = "DELETE * FROM projects WHERE ID='$_SESSION[userid]'";