+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: sql between 2 dates (/showthread.php?tid=33064)
sql between 2 dates - El Forum - 08-14-2010
[eluser]Unknown[/eluser]
Hi, I'm working on "select * from tables where mydate between date_start and date_stop" but I don't know the command in codeigniter "$this->db->where('mydate'..."
sql between 2 dates - El Forum - 08-14-2010
[eluser]the_yk[/eluser]
try this...
Code:
$this->db->where("mydate between date_start and date_stop");sql between 2 dates - El Forum - 08-14-2010
[eluser]Unknown[/eluser]
That's the answer. Thanks.