automatic date field?

[FiveFlat]

I created a simple 'guestbook' form with php and mysql, and I am trying to get the the date field to automatically update when someone signs the guestbook.
Any suggestions would be helpful!

[rupertbj]

Assuming you are using a mysql database to store all the info, just add the variable now() into your mysql insert statement like this:

	$sql = "INSERT INTO guestbookTable VALUES ( '', now(), '$name', '$user', '$message' )";

If you're not using a mysql (or other) database, then you should be!

Hope this helps!

[FiveFlat]

I tried that, but I guess my problem was putting single quotes around now().
I'll try that out tonight.
Thanks!