Query works from shell but not PHP page
Posted 08 May 2003 - 06:34 PM
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,
Posted 09 May 2003 - 12:14 PM
Posted 09 May 2003 - 04:00 PM
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\'
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users