Automaticly adding a date

[danposs86]

i am using a form to add data to a mysql database using php. I am using the following code for the query:

mysql_query("INSERT INTO `site_news` (news_name, news_title, news_post) VALUES ('$_SESSION[user]', '$_POST[title]', '$_POST[news]')");

what i want to do is get the form to add the date in (in the form of DD-MM-YYYY ideally). The field is called 'news_testdate' and is set as a date.I am guessing it will be something like this:

mysql_query("INSERT INTO `site_news` (news_name, news_title, news_post, news_testdate) VALUES ('$_SESSION[user]', '$_POST[title]', '$_POST[news]'), 'NOW()'");

or something along them lines.Any ideas?

[justsomeguy]

Remove the quotes around NOW, you want to execute the function, not store the text "NOW()".

[danposs86]

i managed to work out a different way, which i think will work excellently in the long run:

$news_date = date("d-m-Y");mysql_query("INSERT INTO `site_news` (news_date, news_name, news_title, news_post) VALUES ('$news_date', '$_SESSION[user]', '$_POST[title]', '$_POST[news]')");

thanks anyway mate