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

PHP Code:
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:

PHP Code:
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


PHP Code:
SELECT * FROM visitor ORDER BY date DESC 
and date is stored in this format:
PHP Code:
date datetime NOT NULL default '0000-00-00 00:00:00',