RE: [PHP] Escaping nasty quotes
| From: | Roy W | Date: | Thu, 31 Jul 2003 18:53:06 +0000 |
| Subject: | RE: [PHP] Escaping nasty quotes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-157788@lists.php.net to get a copy of this message | ||
Sorry...Because of the double quote near the ENCLOSED BY .. It delivers a
PARSE ERROR
?
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@niicommunications.com]
Sent: Thursday, July 31, 2003 12:38 PM
To: Roy W; php-general@lists.php.net
Subject: RE: [PHP] Escaping nasty quotes
[snip]
$query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";
{/snip]
try ...
$query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' ";
The period concats were not needed.