delete two ids from two tabels with one click

[ajloun]

Hello

How do u delete two IDs from two tabels in on click .. i tried this , but it only delete ID 1 from tabel one and no change to id in tabel two.

PHP Code:

$sql = "DELETE FROM "._TABLE1." and "._TABLE2." WHERE id1 and id2 = ".intval($_GET['id'] ); 


what i try to do is when delete the ID from tabel 1 to also delete the same id from tabel 2.

[er4o]

Try like this:

PHP Code:

$sql = "DELETE FROM "._TABLE1.", "._TABLE2." WHERE "._TABLE1.".id1 = '" . intval($_GET['id']) . "' AND "._TABLE2.".id2 = '" . intval($_GET['id']) . "'"; 


[ajloun]

thank you but did not delete any

[er4o]

Ahh yes, just tested it at my local host. Got working query:

PHP Code:

if ($_GET['id']) {
$id = intval($_GET['id']);
$sql = "DELETE "._TABLE1.".*, "._TABLE2.".* FROM "._TABLE1.", "._TABLE2." WHERE "._TABLE1.".id1 = '$id' AND "._TABLE2.".id2 = '$id'";
mysql_query($sql);
} 


[ajloun]

er4o that was perfect .. Sorry for delay answering .. i went sleep ..