Welcome Guest, Not a member yet? Register   Sign In
Active Record and CURDATE()
#1

[eluser]al404[/eluser]
i'm using active record for a query but i also would like to set a value of a filed to CURDATE() via SQL, it doesn't work eather with or without quote

how can i do that?

$data = array(
'title' => $title,
'datein' => 'CURDATE()',
other fields...
);

$this->db->update('news', $data);


Messages In This Thread
Active Record and CURDATE() - by El Forum - 01-15-2009, 08:23 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 09:27 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 09:46 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 10:23 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 10:45 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 10:53 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 11:54 AM
Active Record and CURDATE() - by El Forum - 01-15-2009, 12:40 PM



Theme © iAndrew 2016 - Forum software by © MyBB