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