problem using Now() in insert staetment

[tony007]

Hi all could any one tell me what is wrong with this sql statment it keeps giving error after i try to use Now function(No record entered).


Fatal error: Call to undefined function: now() in /date2.php on line 49

mysql_query("INSERT INTO visitor VALUES('$ID','$HTTP_X_FORWARDED_FOR',[B]'". NOW() ."'[/B],'$countryName','$country')"); 

also i tried this and did not insert any records:

mysql_query("INSERT INTO visitor VALUES('$ID','$HTTP_X_FORWARDED_FOR',[B]Now(),[/B]'$countryName','$country')"); 

My intention is to record and output visitor information acording to date and time . I hope some one help me what i am doing wrong here .THanks

SELECT * FROM visitor ORDER BY date DESC 

and date is stored in this format:

date datetime NOT NULL default '0000-00-00 00:00:00', 

[penagate]

now() is a SQL function, not a PHP one. Put it inside the quotes for the query.

[mendhak]

There's a whole bunch of MySql functions you can use to get the current date as well:

http://dev.mysql.com/doc/refman/5.0/...functions.html

[lintz]

Use Time()