Posted by HawkEye on 06/28/05 22:01

Terry wrote:
> 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
>

Are you trying to use the current date (ie today) ? If so use curdate() or
now(). One is for date and one datetime (I forget which)

HTH

--
Regards

Neil

Registered Linux User 324599
If vegetarians eat vegetables, beware of humanitarians!

[Back to original message]