Delete from multiple tables..

[haku87]

I have four tables.. t1,t2,t3,t4

t1 has a field called "id"

t2 has a field called "quizid"

t3 has a field called "quizid"

t4 has a field called "quizid"

 

I wan to delete all entries in these four tables which has a same id as $_POST[id].

The sql statement that i wrote cannot be use.. How to write the sql statement...

 

"DELETE tblquizmanagement, tblsaqmanagement, tblmcqmanagement,tbl_essay_ans FROM tblquizmanagement AS t1,tblsaqmanagement AS t2,tblmcqmanagement AS t3,tbl_essay_ans AS t4 WHERE t1.id ='".$_GET['quizid']."' AND t2.quizid = t1.quizid AND t3.quizid = t1.quizid AND t4.quizid = t1.quizid"

 

 

 

 

 

[Caesar]

<?php

$tables = array('t1','t2','t3','t4');
$id = $_POST[id];
$id_field = 'id';
$i = 1;

  foreach($tables as $t) {

    if($i > 1)$id = 'quizid';
    $DB->query("DELETE FROM `".$t."` WHERE `".$id_field."`='$id'");
    $i++;
  }

?>

[Caesar]

Corrected...(Wouldn't let me edit)

<?php

$tables = array('t1','t2','t3','t4');
$id = $_POST[id];
$id_field = 'id';
$i = 1;

  foreach($tables as $t) {
    if($i > 1) $id_field = 'quizid';
    $DB->query("DELETE FROM `".$t."` WHERE `".$id_field."`='$id'");
    $i++;
  }

?>

[haku87]

Is there a way to delete all the four table with quiz id = 3 in one sql query?

[shedokan]

maybe try:

DELETE FROM `t1` WHERE `id'='3'
DELETE FROM `t2`,`t3`,`t4` WHERE `quizid'='3'