[SOLVED] Deleting data from two tables simultaneously

[eluser]Unknown[/eluser]
I used the above code but get database error

Code:

A Database Error Occurred

Error Number: 1109

Unknown table 't2' in MULTI DELETE

DELETE t1, t2 FROM tech_static_pages t1 tech_navigation t2 ON t1.id = t2.page_id WHERE t1.id = '22'

Filename: E:\wamp\www\techinfi\system\database\DB_driver.php

Line Number: 330

But I resolved it by using JOIN keyword as

Code:

function delete_page($page_id)
{
  return $this->db->query("
    DELETE t1, t2
    FROM tech_static_pages t1 JOIN tech_navigation t2
    ON t1.id = t2.page_id
    WHERE t1.id = '".$page_id."'");
}

My code is working fine using JOIN keyword.

Thanks,
Tikendra Maitry
Tiks.in