How to insert date variable into my sql

[Anon]

I am having problems inserting the date into a mysql database. This is the code I am using:

$date = getdate();
$sql = "insert into mynewads values (\"$description\", \"$date\")";

It does insert the date, but always as a line of zeros..

[notionlogic]

Were you aware that, according to the manual, the "getdate()" function returns:

..an associative array containing the date information of the timestamp, or the current local time if no timestamp is given...

For example if you are using a DATE field then you would need to code it something like this...

$date = getdate();
$sqldate = $date[year]."-".$date[mon]."-".$date[mday];
$sql = "insert into mynewads values ('$description', '$sqldate')";

This should give you the idea but I haven't tested it myself as I would normally set up the SQL like this:

$sql = "insert into mynewads values ('$description', now())";

Hope this helps

[Anon]

If you set the database field to not null and the type to timestamp (which is a valid mysql data type) the database will fill in the timestamp for you, without any php, then you can use the php time/date functions to display it as you wish at the other end.

hope this helps, -Tim

[Anon]

Thank you, that worked..