Re: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Chris
Chris Carter wrote: Is there something that has changed in the new MySql DB ? What new mysql? Has your host upgraded your database version or something? Mysql won't change the interface between versions except to improve it. I am trying to upload a data like this from my CSV file to a table

RE: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Gary Wardell
Chris, If you're using spaces for enclosing then I'm sure you're not handling something properly. Chris,Carter,[EMAIL PROTECTED] -- 3 records Chris Carter,[EMAIL PROTECTED] -- 2 records Don't you mean: Chris,Carter,[EMAIL PROTECTED] -- 3 *fields* Chris Carter,[EMAIL PROTECTED] -- 2

Re: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Chris
Gary Wardell wrote: Chris, If you're using spaces for enclosing then I'm sure you're not handling something properly. Chris,Carter,[EMAIL PROTECTED] -- 3 records Chris Carter,[EMAIL PROTECTED] -- 2 records Don't you mean: Chris,Carter,[EMAIL PROTECTED] -- 3 *fields* Chris

Re: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Chris Carter
I am not using spaces for closing. Every field is tightly packed with comma only. No spaces, no semicolon. The reason I used space is if I use space at least 3 or 4 fields get uploaded but not all. But we can ignore space for now as it happened earlier. I am using the CSV import option from

Re: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Chris
Chris Carter wrote: I am not using spaces for closing. Every field is tightly packed with comma only. No spaces, no semicolon. The reason I used space is if I use space at least 3 or 4 fields get uploaded but not all. But we can ignore space for now as it happened earlier. Then your issue will

[PHP-DB] Importing CSV files to MySql Db issue.

2008-02-15 Thread Chris Carter
Is there something that has changed in the new MySql DB ? I am trying to upload a data like this from my CSV file to a table through CSV upload and not CSV Load Data: field1,field2,field3,field4,field5,field,6,field7,field8 field1,field2,field3,field4,field5,field,6,field7,field8 Parameters I