Selecting between a date

[eluser]SeanJA[/eluser]
Actually, I think this might work better...

Code:

$query = $this->db->query("SELECT * FROM exhibitions WHERE startDate <= '$date' AND endDate >= '$date'");
$result = $query->result();
return $result; //return an array of the exibitions that are between startDate and endDate