Commas conundrum
| From: | Anne Shroeder | Date: | Sat, 02 Oct 2004 00:25:26 +0000 |
| Subject: | Commas conundrum | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-24680@lists.php.net to get a copy of this message | ||
I'm trying to import a .csv file into a table. One of the columns of the
.csv file looks like this: Manila, Philippines. I want this data to go into
one field: "address"
When I do the import with stripslashes (magic_quotes_gpc is turned on) it
does this:
insert into helpdesk values( '0', '"Manila',
'Philippines"')
which obviously doesn't work. What am I doing wrong?
Anne