Update date in MySQL

[Anon]

Hi,
I am having trouble to update the date in the MySQL table. I am using PHP to update the MySQL table.

$d=date("Y m d")

$query="update table1 set tabledate='$d' where id=1";

After I run this query, I can only get the "0000-00-00" from the table1.

Could anyone tell me what's wrong here?

Thank you very much!

Rong

[Anon]

hmmm......try date("Y-m-d") instead of date("Y m d").

hope this helps....

[Anon]

Yup, try what he said...