Active record and date in where statement

[eluser]mddd[/eluser]
Smilie, the code is ok. The question is: what is in $date.

CI's db->where() is mostly suited for comparing EQUAL things. If you say where($a, $b) it will basically find records where field $a has the value $b.
When things get a bit more complicated (like using functions in the Mysql code, or comparing 'larger than' etc. its works better to write the code yourself and put it in a single string. Compare that to "nothing" (empty string) and make sure that escaping is off (third parameter : false).

Then you get (like I wrote before

Code:

$this->db->where('created >= NOW() - INTERVAL 1 DAY', '', false);

And that should work fine.