Sorry...Because of the double quote near the ENCLOSED BY .. It delivers a
PARSE ERROR

?



-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 31, 2003 12:38 PM
To: Roy W; [EMAIL PROTECTED]
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.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Reply via email to