Delete data in two tables at the same time
Posted: Fri Jun 26, 2009 1:32 am
hi can someone help me..i need to delete data in two tables at the same time..here is my sql code..it won't work..thank you
$data = $_POST['data'];
mysql_query("DELETE FROM table1 WHERE column='$data'; DELETE FROM table2 WHERE column='$data'")
$data = $_POST['data'];
mysql_query("DELETE FROM table1 WHERE column='$data'; DELETE FROM table2 WHERE column='$data'")