[Solved] Delete not working properly as wanted

Did you try

PHP Code:

$this->db->where('code >',''); 


This has worked now using a foreach loop

PHP Code:

public function clear_unconfirmed_post() {
        $this->db->select('*');
        $this->db->from($this->db->dbprefix . 'post');
        $query = $this->db->get();
        foreach ($query->result_array() as $result) {
            if (!empty($result['code'])) {
                $this->db->where('code', $result['code']);
                 $this->db->where('date_created < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 15 MINUTE))', NULL, FALSE);
                $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!