CodeIgniter Forums
Complex statements using active record - Printable Version

+- 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: Complex statements using active record (/showthread.php?tid=34537)



Complex statements using active record - El Forum - 10-02-2010

[eluser]blasto333[/eluser]
Is it possible to do:

SELECT * FROM table WHERE (a=b or a=c) and d=e


Complex statements using active record - El Forum - 10-02-2010

[eluser]Dennis Rasmussen[/eluser]
I don't think so, however you can write your own clauses manually:

Code:
$where = "(a=b or a=c) and d=e";
$this->db->where($where);