Deleting from three tables at once

[zed420]

Hi All

Can someone tell me if this  is possible or do I need to wake up. I'm trying to delete some records from three different tables at once via check boxes, tabls don't have any join. This doesn't give me any error but not working either. It does work if I use one table. some help will be greatley appreciated.

		if($_POST['delete']) {
	foreach($_POST as $job_id) { 
	mysql_query("DELETE FROM job_tb,blockBook,blockBook2
	 WHERE job_tb.job_id='$job_id' OR 
	 blockBook.job_id= '$job_id' OR 
	 blockBook2.job_id= '$job_id'"); 
	if (mysql_affected_rows() > 0) { 
    	print "<font color=red size=2>Job No. = $Job_id has been deleted</font><p>"; 
  		} 
}
}

Thanks

Zed

[Barand]

try

DELETE job_tb.*, blockBook.*, blockBook2.*
FROM job_tb
    INNER JOIN blockBook USING (job_id)
    INNER JOIN blockBook2 USING (job_id)
WHERE job_tb.job_id = '$job_id'

[zed420]

Thanks for the reply Barand It didn't work .

 

Zed

[Barand]

If there are no matching job_ids you'll need 3 separate deletes