Can someone tell me what I'm doing wrong:

$time = time();
$sql = "INSERT INTO articles (title, description, bodyText, created) VALUES ('$new_title', '$new_description', '$new_bodyText', '$time')";
$result = mysql_query($sql);

It all seems to work OK but my "created" field has "0000-00-00 00:00:00" instead of the current time.

Thanks for any pointers.

What's the data type of your 'created' column? If it's not an integer or unix timestamp, you can't just insert an integer into it.

You need to convert the unix timestamp into a the DATETIME format that MySQL expects (the "0000-00-00 00:00:00" looks like DATETIME to me...)

You can do this using either PHP *or* MySQL.

PHP:
$datetime = date("Y-m-d H:i:s", time());
$sql = "INSERT INTO articles
           (title, description, bodyText, created)
        VALUES
           ('$new_title', '$new_desc', '$new_bodyText', '$datetime')";

MySQL:
$time = time();
$sql = "INSERT INTO articles
           (title, description, bodyText, created)
        VALUES
           ('$new_title', '$new_desc', '$new_bodyText',
            FROM_UNIXTIME($time))";

For more info, read the manuals:
  http://www.php.net/date
  http://www.mysql.com/doc/en/Date_and...functions.html


Take care,

Nik
http://www.bigaction.org/

Thanks Nikolai - that's what I've been doing wrong!