automatically insert date() into table

Anon

I have mysql database using php script.

When someone click submit, I want to automatically insert date() into my datbase table1 containing column called as add_date.
The add_date column's datatype is datetime.

In my submit form, I have a hidden field for variable "add_date". But when I trigger submit, nothing insert into my database table. But If I got rid of "add_date" column, my script is ok.

Anyway, need to get help how to insert date() automatically into my database table.

Appreciate any help,

Anon

sure -
The insert command should be as follows:

INSERT INTO tablename (add_date) VALUES (now());

Anon

what is the value of your add_date field if you are just using date() the script is failingat the date ecause the are no parameters try using this in your value

<input type=hidden name=add_date value=date("Y-m-d h:i:s")>
the format to datetime is
0000-00-00 00:00:00

Anon

When I typed

<input type=hidden name=add_date value=date("Y-m-d h:i:s")>
in my html's form, then in my php script added

insert table1 (field1, field2, add_date) values('$field1', '$field2', now());

None of my fields were insert into my table. But If I removed all add_date field in my HTML form and php script, everything works fine.

Please Help!

Anon

should be:
form:
<input type=hidden name=add_date value=date("Y-m-d h:i:s")>
in my html's form, then in my php script added

Insert Script:

$sql = "INSERT INTO $table
(field,feild2,add_date)
VALUES
{'$field','$feild2,'$add_date');

Anon

I tried couple of times like that, it seemed that I still couldn't make it work.

I am not sure that will be related to my hidden field? Because my hidden field seem giving me trouble. But I don't know how to fix it now.

Any ideas?