RE: [PHP-DB] Importing CSV files to MySql Db issue.
| From: | Gary Wardell | Date: | Sun, 17 Feb 2008 23:38:27 +0000 |
| Subject: | RE: [PHP-DB] Importing CSV files to MySql Db issue. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44618@lists.php.net to get a copy of this message | ||
Chris,
> If you're using spaces for enclosing then I'm sure you're not
> handling
> something properly.
>
> Chris,Carter,email@address.com <-- 3 records
> Chris Carter,email@address.com <-- 2 records
>
Don't you mean:
Chris,Carter,email@address.com <-- 3 *fields*
Chris Carter,email@address.com <-- 2 *fields*
And both only result in one record for each CSV line?
Or do PHP and MySql handle CSV files different from most other applications?
Gary