MySQL NOW() giving blank result

[Fsoft]

Hey,

 

I am using this query

$querywritingguest = mysql_query("INSERT INTO onlineguests (guestip, guest_active_time) VALUES (\"$guestip\",'NOW()')");

 

This is query I am writing in my database for guest and NOW() is used because after a particular time, I will be deleting old entries, but problem is that now is giving a blank result like this :

 

0000-00-00 00:00:00

 

In database we have two fields, guestip (varchar) and guest_active_time (TIMESTAMP)..

 

I don't get what Am I doing wrong

 

Please help me.. Thanks!

 

FAISAL!

[zenag]

mysql_query("INSERT INTO onlineguests (guestip, guest_active_time) VALUES (\"$guestip\",NOW())");

REMOVE SINGLE QUOTE FOR now()