php parse error

napkdd1 · November 17, 2006 7:07 am

Hi,

Could someone help me figure out why I get the a parse error when running this MySQL query?

Here is the statement getting an parse error

$readdata = "LOAD DATA INFILE 'customer1.csv' INTO TABLE 'customer1' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";

Thanks!

phppat · November 17, 2006 4:27 pm

Easy fix, you've got a " within your " quoted variable that should be escaped by a slash.. try this instead:

$readdata = "LOAD DATA INFILE 'customer1.csv' INTO TABLE 'customer1' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";

Hope that helps!

November 17, 2006 7:07 am

php parse error

November 17, 2006 4:27 pm

Re: php parse error