Date Issue when inserting into MySQL

[DoctorWho]

I use this format in PHP to get a date.

date("Y-m-d");

And I use the proper field in MySql and get the proper date most of the time in my file upload form.

But I am currently getting a user then when she uploads a new file, it puts and old date in MySql, in this case 2005-12-05, instead of todays date, 2005-12-21.

When I upload a file I get the proper date inserted into mysql.

I have turned off Caching options with headers:

header("Cache-Control: no-store, no-cache, must-revalidate");
header("Expires: Mon, 26 July 1997 05:00:00 GMT");
header("Pragma: no-cache")

But the auto date is still posting the date of 2005-12-05.

Any Ideas before I quit IT for good?

[devinemke]

if you simply want to enter the current date into the db then just use mySQL's CURDATE() fucntion. read up on the Date and Time Functions.