Query works from shell but not PHP page

[daverose]

Hi,

 

I have a query that I\'m attempting to load from a PHP page that is not working. However, the exact same query works just fine when I run it from the MySQL command line.

 

This is the query:

LOAD DATA LOCAL INFILE \'/home/ratdog/public_html/test.txt\' INTO TABLE `shows`

 

I\'ve run similar queries through PHP with no problem, and I\'m absolutely stumped on why this won\'t work when it works fine from the command line.

 

Thanks for any help,

 

Dave

[effigy]

a. does the webserver have access to that directory/file?

b. are you connecting to the db with a use that has the permission to run the query?

[daverose]

Yes. I can run that same query that imports the data from that same file if I type it at the command line. Nothing happens from PHP though. (The same PHP script has other queries of the database, and those work properly.)

 

Thanks.

[daverose]

By the way, I get the error:

 

ERROR: The used command is not allowed with this MySQL version

 

if I make it `shows` instead of \'shows\'

 

 

 

I get the error:

 

ERROR: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'\'shows\'\' at line 1

 

if I leave it as \'shows\'