Hi guys,
I have come with another problem..
I am using MySql database and coding in PHP. I have a "members" table with a field for the member's date of birth. I validate the date and store them to my table in the mysql format (yyyy-mm-dd).
But, the dates are all stored wrong. Most of the time, it is stored as 0000-00-00 or just makes up it's own date.
For example: For a date like 2002-12-12, it stores as 0000-12-00 or 2000-00-12.. (The way it stores is infinite possibilities.. everytime in a new way!)
Why does that happen? I cannot rely on the dates I retrieve if it happens like this.. Where should I check? PLEASE HELP!!!!!!!!!!!!!!
Thanks.
Amy.