[SOLVED] Now() function

[limitphp]

I'm using this query:

mysql_query("INSERT INTO vote (artistID, songID, date, userID) 
		VALUES ('$artistID', '$songID', 'NOW()', '$userID')");

 

In the table when it inserts it, the date is not working.

The date type is datetime.

How do I get it to show as ex) 2008-11-04 08:10:25.

 

Thanks

[rhodesa]

remove the single quotes around NOW():

mysql_query("INSERT INTO vote (artistID, songID, date, userID)
         VALUES ('$artistID', '$songID', NOW(), '$userID')");

[limitphp]

remove the single quotes around NOW():

mysql_query("INSERT INTO vote (artistID, songID, date, userID)
         VALUES ('$artistID', '$songID', NOW(), '$userID')");

 

Thank you....