PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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 with ONE table at a time thou. 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>";
}
}
}
zed420 wrote: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 with ONE table at a time thou. some help will be greatley appreciated.
Only possible if your database supports triggers, and you write ON DELETE triggers to handle the deletions from the other tables... then you'd just delete from the one table with the trigger, and the database would delete from the other two. Even then, though you still need a join across the tables.
Otherwise, you just have to delete from each individually.
If your database supports transactions then you delete them each in turn before committing the transaction
zed420 wrote: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 with ONE table at a time thou. some help will be greatley appreciated.
Only possible if your database supports triggers, and you write ON DELETE triggers to handle the deletions from the other tables... then you'd just delete from the one table with the trigger, and the database would delete from the other two. Even then, though you still need a join across the tables.
Otherwise, you just have to delete from each individually.
If your database supports transactions then you delete them each in turn before committing the transaction