mysql datatype date problem

[vineet]

hi all

just joined the forum.

i would like to ask that i have set the "datatype" of my date column to "date" in phpmyadmin table i created.

It fetches date from a php form. But when i enter any date say example 1982/10/10 then everytime it displays as 0000-00-00.

vineet

[Wiedmann]

But when i enter any date say example 1982/10/10 then everytime it displays as 0000-00-00.

Read the MySQL manual about correct values:
http://dev.mysql.com/doc/refman/5.0/en/datetime.html