[Solved] Delete row if key code is there for more than 15 min

Just perform a single sql

Code:

DELETE FROM post
WHERE date_modifieda < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 15 MINUTE))

I tried this but does not work

PHP Code:

public function clear_unconfirmed_post() {
     $this->db->where('code is NOT NULL', NULL, FALSE);
     $this->db->where('date_modified < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 15 MINUTE))');
     $this->db->delete($this->db->dbprefix . 'post');
} 


There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!