Posted by Terry on 06/28/05 21:47

Joseph Melnick wrote:
> 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
>>
>
>
> Hello Terry,
>
> Did you try to optionally quote the date field on import?
>
> "2005-05-23";hello;
I have now - same result.
"2001-21-06";hello; \r\n
"20002106";goodby; \r\n
Yields:
Date comment
0000-00-00 hello
0000-00-00 goodby

--
TK
http://www.wejuggle2.com/
Still Having a Ball (even if I am lost ;-)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

• Next in forum: Two simple questions... with reagrd to PHP and MySQL
• Prev in forum: Re: Loops all messed up [solved]
• Thread view: Re: Dumb Question of the day (maybe year)

[Reply to this message]