date question

[Anon]

I am making a guestbook, with forms and php. I'd like to know, how do I insert the date from php to the db? i would use curdate, but being i am using variables from a form and not inserting records with mysql monitor, i was wondering how to do that

[bretticus]

The easiest way is to simply set up your database table with a timestamp or self-perpetuating date field.

For example, in MySQL, you create a field of TIMESTAMP type. Anytime a new record is inserted, that field will become populated with the current time.

[Anon]

ok I changed the database table to have the date field be type timestamp
but what would I tell my php script to put in that field?
if this makes a difference, I am doing the insert like this:
$sql = "insert into mytable values ('','$name','$email','$othervalues)";
in this case, what would i put for the value would i put '$date' or '' or what

i hope i asked this clearly enough.

[bretticus]

Yeah, sure...

You can ignore it completely in your query from php. The database will take care of the timestamp.

Happy coding...