insert in to TIMESTAMP field using ActiveRecords

[eluser]Michael Wales[/eluser]
The now() function within the date helper returns a Unix timestamp. First, I highly, highly, recommend you use Unix timestamps instead of MySQL timestamps - it will make your life much easier.

If you insist though... try this:

Code:

$profile_data = array(
              'member_id' => $member_id ,
              'membername' => $membername ,
              'profiledescription' => '' ,
              'lastlogin' => date('Y-m-d H:i:s', now()),
              'status' => 1,
                );

PHP's date() function accepts a string representing a format for the date and an optional Unix timestamp, for the timestamp you would like to convert into the strings representation.