Selecting between a date

Selecting between a date

El Forum
Guest

06-27-2008, 10:29 AM

[eluser]SeanJA[/eluser]

Code:
$date = date("Y-m-d");

$this->db->query("SELECT * FROM exhibitions WHERE '$date'  >= date AND '$date' <= endDate");

$whats>db->get();

return $whatsOn_data->result_array();

Shouldn't $whatsOn be $whats ?

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: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