[PHP] Question About Date Function in PHP/MySQL

2004-02-08 Thread Freedomware
I'm using PHP to display a MySQL table. I've got everything working fine except the date function. I designated the first two fields VARCHAR. Those columns display just fine when I preview my web page, as do all the other columns except the third. I designated that one DATE. (The field name is

Re: [PHP] Question About Date Function in PHP/MySQL

2004-02-08 Thread John W. Holmes
Freedomware wrote: When I view my data in phpMyAdmin, all I see in that column is NULL. When I preview it in a webpage, nothing displays at all. If I change it to NOT NULL, I see -00-00 in every cell. Here's a row of text from the CSV file I imported into my MySQL table:

Re: [PHP] Question About Date Function in PHP/MySQL

2004-02-08 Thread Freedomware
John W. Holmes wrote: Freedomware wrote: When I view my data in phpMyAdmin, all I see in that column is NULL. When I preview it in a webpage, nothing displays at all. If I change it to NOT NULL, I see -00-00 in every cell. Here's a row of text from the CSV file I imported into my MySQL

Re: [PHP] Question About Date Function in PHP/MySQL

2004-02-08 Thread John W. Holmes
Freedomware wrote: EMS lists the following: Short Date: M/d/ Long Date: , dd, Day followed by month, followed by another day, then year??? That format means something like Friday, May 5, 2004 I thought it was supposed to be year first, followed by month and day, as in the

Re: [PHP] Question About Date Function in PHP/MySQL

2004-02-08 Thread Freedomware
John W. Holmes wrote: Freedomware wrote: EMS lists the following: Short Date: M/d/ Long Date: , dd, Day followed by month, followed by another day, then year??? That format means something like Friday, May 5, 2004 I thought it was supposed to be year first, followed by month