mysql datetime help

[GundamSV7]

Hey, here's my code so far:

mysql_query("INSERT INTO chat (user,msg,time) VALUES ('$user','$msg','NOW()')");

but the now() function doesn't seem to work with the datetime field in my mysql database, any idea what I should put there to store the current datetime into my db?

[devinemke]

lose the single quotes around NOW()

[GundamSV7]

cool, thanks, it works great now 🙂