RE: [PHP] Escaping nasty quotes
| From: | Jay Blanchard | Date: | Thu, 31 Jul 2003 18:38:02 +0000 |
| Subject: | RE: [PHP] Escaping nasty quotes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-157786@lists.php.net to get a copy of this message | ||
[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.