Working with CURRENT_TIMESTAMP

[eluser]CroNiX[/eluser]
for more complex wheres (using functions), you probably need to enter it as a single string.

Code:

$this->db->where('CURDATE() BETWEEN ' . $startDate . ' AND ' . $endDate);

When using functions in selects, you should do something like:

Code:

$this->db->select('id');
$this->db->select('COUNT(id) AS total', FALSE);

use FALSE for 2nd parameter so it won't protect the identifiers which messes up on function names

And as always, run a

Code:

echo $this->db->last_query();

to see what SQL was actually compiled from AR.