Show your code and table set-up. That would help.
-----Original Message----- From: Dave Pollak [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] import error into mySQL Howdy, New to databases, mySQL, and PHP. In my first PHP/mySQL application I'm loading data from a flat file exported from a Paradox database. Dates in one field import as 0000-00-00 though they import properly in other fields. They appear to be configured alike - dob DATE & date_reg DATE - and the data in the text file is correct. Loaded data from local infile declaring delimiter as ',' and field enclosure as '"' (double quote). Also have run some select queries where field_name is null that do not return any rows yet visual examination of fields after select * query shows no data. Thoughts? Dave Pollak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]