Selecting between a date - Printable Version

Selecting between a date - 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: Selecting between a date (/showthread.php?tid=9494)

Pages: 1 2

Selecting between a date - El Forum - 06-30-2008

[eluser]E303[/eluser]
I re-wrote it like this and it worked thanks.

Code:
$this->db->select('exhibitionsId, title, url, picture, date, endDate');

            $this->db->from('exhibitions');

            $this->db->where('date <=', $date);

            $this->db->where('endDate >=', $date);

            $whatsOn_data = $this->db->get();

            return $whatsOn_data->result_array();