Welcome Guest, Not a member yet? Register   Sign In
Selecting between a date
#11

[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();


Messages In This Thread
Selecting between a date - by El Forum - 06-27-2008, 01:14 AM
Selecting between a date - by El Forum - 06-27-2008, 01:32 AM
Selecting between a date - by El Forum - 06-27-2008, 01:46 AM
Selecting between a date - by El Forum - 06-27-2008, 01:46 AM
Selecting between a date - by El Forum - 06-27-2008, 01:49 AM
Selecting between a date - by El Forum - 06-27-2008, 02:10 AM
Selecting between a date - by El Forum - 06-27-2008, 10:29 AM
Selecting between a date - by El Forum - 06-27-2008, 10:38 AM
Selecting between a date - by El Forum - 06-27-2008, 11:50 AM
Selecting between a date - by El Forum - 06-27-2008, 12:46 PM
Selecting between a date - by El Forum - 06-30-2008, 09:06 PM



Theme © iAndrew 2016 - Forum software by © MyBB