Active record and date in where statement

[eluser]mddd[/eluser]
To prevent the wrong values from being escaped by CI, use 'false' as the third parameter in where().

Code:

$this->db->where('created >= '.$date, '', false);

By the way, if you want to find stuff newer than 1 day ago, why not do this:

Code:

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

I often see people doing things in php that could be done in Mysql with less hassle.