Posted by ChrisLive on 06/30/05 18:00

Terry wrote:
> I am using phpMyAdmin to access MySQL for inputting data - built one
> table - no problems. I am uploading text files using ; as a delimiter.
> Second table includes a date (configured as date not datetime). I have
> tried:
> 2001-21-06;hello; \r\n
> 20002106;goodby; \r\n
> '2001-21-06';hello; \r\n
> '20002106';goodby; \r\n
>
> All I get is:
> Date comment
> 0000-00-00 hello
>
> I have looked at the manual for MySQL and php, googled - this is so
> simple no one else has a problem, right?
>
> TIA
>
Maybe the problem is that you are sending YYYY-DD-MM try YYYY-MM-DD

[Back to original message]