MySQL date/time

[vertmonkee]

In the following sql i want to insert the current date and time into date_added.

$insertsql = "INSERT INTO `spot_location` " .
"( `location_id` , `address_line_1` , `address_line_2` , `town` , `county` ," .
" `country` , `postcode` , `username` , `date_added` , `main_image_location` ) " .
" VALUES ( " .
" '', '" . $_POST['address_line_1'] . "', '" . $_POST['address_line_2'] . "', " .
" '" . $_POST['town'] . "', '" . $_POST['county'] . "', '" . $_POST['country'] . "', " .
" '" . $_POST['postcode'] . "', '" . $_SESSION['user_logged'] . "', 'NOW()', 'image location')";

How do i go about this please?

thanks

[devinemke]

use the NOW() function

[vertmonkee]

I can get the now() function to work by itself.

is it possible to add it into the sql i have posted. I have tried is the syntax wrong or am i way off.

Or will i have to perform a seperate sql statement just to add the date in?

thanks for the quick response earlier.

[devinemke]

remove the quotes around NOW()