RE: [PHP-DB] import error into mySQL

Show your code and table set-up. That would help. -----Original Message----- From: Dave Pollak [mailto:dave@ci.bedford.nh.us] Sent: Thursday, October 25, 2001 1:37 PM To: php-db@lists.php.net 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net