CURDATE() and INTERVAL in codeigniter

[eluser]InsiteFX[/eluser]
You can try this, but then you will need to use set on all the fields.

Code:

$this->db->set('date_finish = DATE_ADD(CURDATE(), INTERVAL 30 DAY)');

// or
$array = array('id_products' => $id_products, 'date_start' => CURDATE(), 'date_finish' => 'DATE_ADD(CURDATE() + INTERVAL 30 DAYS)');