[PHP-DB] CSV import to mySql

Hi, I have this data given below as sample. Trying to import to mySQL is failing everytime. There are more than 100 rows of data but when I follow the procedure of phpMyadmin databasename tablename click import tab from top choose the file (csv file) Click on the CSV radio button on Format

Re: [PHP-DB] CSV import to mySql

Chris Carter wrote: Hi, I have this data given below as sample. Trying to import to mySQL is failing everytime. There are more than 100 rows of data but when I follow the procedure of phpMyadmin databasename tablename click import tab from top choose the file (csv file) Click on the CSV

Re: [PHP-DB] CSV import to mySql

Hi Your example data does have an invalid field count The first row has has 7 fields, the other 6. So if you took them from your actual data that's your problem Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php