The problem is as follows :
How to get the LOAD_FILE() command to work in a .php script?
I have tested the command itself in mySQL and it works fine. (I am trying to import a .txt file into one field of a table)
I have used the command as follows :
INSERT INTO common VALUES
(1, 1, LOAD_FILE(\"e:\\1.txt\"), NULL, \'N\');
and it worked the way i wanted it - so there can\'t be any problems with the database itself.
Then I tried to use the same command in a php script :
$address = \"e:\\\\1.txt\";
$load_file = \"INSERT INTO common VALUES
(\'$row[$x]\',$user\',LOAD_FILE(\"$address\"),\'NULL\',\'N\')\";
$result = mysql_query($load_file);
then the page containing the script reloads for quite a long time, and when I check mySQL what actually happened I get the output :
1,1,NULL,NULL,N
WHAT\'S WRONG WITH THE SCRIPT???
the command in mySQL imports the data correctly, the script fails to do so.
HEEEEEELP!!!!