SQL Query - LOAD DATA LOCAL INFILE

[The_Chancer]

I am having a little problem with this query....

$query=do_query("LOAD DATA LOCAL INFILE '".$the_file_name."' INTO TABLE '".$tablename."' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\\r\\n'"); 

$the_file_name and $tablename come out OK yet it says I have an error as follows:

Error in sql: You have an error in your SQL syntax near ''fred' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'' at line 1 Using: LOAD DATA LOCAL INFILE '/tmp/phpNoPUeg' INTO TABLE 'fred' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

Anyone have any ideas ?

[patmcv]

What I would do is comment out the line which is trying to execute the query and do this instead - you should see the problem.

$sql = "LOAD DATA LOCAL INFILE '".$the_file_name."' INTO TABLE '".$tablename."' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'"
echo $sql;

[The_Chancer]

Doing so produces...

LOAD DATA LOCAL INFILE 'C:\\DOCUME~1\\chancand\\LOCALS~1\\Temp\\php3.tmp' INTO TABLE 'bob' FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\r\n'

Which to me looks OK...

Any further ideas ?

[The_Chancer]

$query=do_query("LOAD DATA LOCAL INFILE \"$the_file\" INTO TABLE $tablename FIELDS TERMINATED BY ',' ENCLOSED BY '\"'");

Solved the problem....