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/