+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: how to delete multiple table using codeigniter (/showthread.php?tid=53351)
how to delete multiple table using codeigniter - El Forum - 07-20-2012
[eluser]Crackarjack[/eluser]
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."'");
}enjoy.. .
how to delete multiple table using codeigniter - El Forum - 07-20-2012
[eluser]rwestergren[/eluser]
You're using double quotes, so no need to concatenate the string:
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");
}how to delete multiple table using codeigniter - El Forum - 07-20-2012
[eluser]Crackarjack[/eluser]
oops its working..
cheers