Posted by Joseph Melnick on 06/28/05 19:51

Terry wrote:

"Terry" <tknospa@wejuggle2.com> wrote in message
news:42c144fb$1_1@spool9-west.superfeed.net...
>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
>
> --
> TK
> http://www.wejuggle2.com/
> Still Having a Ball

Hello Terry,

Did you try to optionally quote the date field on import?

"2005-05-23";hello;

Joseph Melnick
JM Web Consultants
http://www.jphp.com/

[Back to original message]