Re: Dumb Question of the day (maybe year)

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
.

Relevant Pages

  • Re: Dumb Question of the day (maybe year)
    ... Joseph Melnick wrote: ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ... Still Having a Ball ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ... If vegetarians eat vegetables, beware of humanitarians! ...
    (alt.php)
  • Re: Registry value keeps resetting
    ... Standard Time), and on a whim, PA Bear [MS MVP] pounded out on the keyboard: ... Terry R. wrote: ... removes anything below the delimiter) caused everything below your reply ...
    (microsoft.public.windowsxp.general)
  • Re: Annoying Warnings After Deleting Files
    ... The date and time was Thursday, April 09, 2009 8:08:56 AM, and on a whim, Terry R. pounded out on the keyboard: ... whim, John Keiser pounded out on the keyboard: ... removes anything below the delimiter) caused everything below your reply ...
    (microsoft.public.windowsxp.general)