Is it ok to delete like this $this->db->delete('freebook', array('day <' => $yesterday));

[eluser]RobertSF[/eluser]
You're welcome! By the way, now that I look closer, you don't have to check first to see if there are any entries to delete. You can just do

Code:

$this->db->delete('freebook', array('day <' => date("Y-m-d")));

If you want to determine if the query deleted any rows, you can do it after the above code, like this

Code:

$deleted_count = $this->db->affected_rows();