hi im just new to mysql and is having problems with auto inserting date in my table.

I dont know what is the default value i will set if column type to DATE. It was succesful though if is use the TIMESTAMP type in the column and is using CURRENT_TIMESTAMP as the dafault value. mysql automatically inserts the current date and time to the database everytime a new record is inserted. The problem with using TIMESTAMP is that i only want the date and not the additional time.

Is there a default value I can use for the DATE function instead of using TIMESTAMP? I already tried NOW(), CURDATE(), CURRENT_DATE() to no avail :S

any suggestions will be much appreciated.

$time1=date("G:i:s");
INSERT INTO table1 (time) VALUES ('$time1')";

thanks for the info, i guess i can put the date value to a hidden field and pass it to the database. thanks again for the idea. :)