insert date

[eluser]Phil Sturgeon[/eluser]
Had a similar problem myself, it will try to treat that entry like it is a string - meaning it will put data = "NOW()" instead of date = NOW().

Use the code:

Code:

$input = array(
    'title'            => $title,
    'description'             => $desc,
    'tag'             => $tag,
    'attachment'            => $file,
    'max'            => $max,
    'date'            => date('Y-m-d h:m:s')
// or the unix version
    'date'            => now()
    );
$this->db->insert('some_table',$input);

For the 2nd option you will need date helper loaded. Or just use the time() function, they do almost the exact same thing except for it can be turned to local timezone or GMT timezone in the CI config.