Problem With LOAD DATA LOCAL INFILE?

[Mark_Nordstrom]

$result = mysql_db_query('leaguem_leaguemanager' ,"LOAD DATA LOCAL INFILE '/usr/local/mysql/$form_data1' INTO TABLE stats FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 5 lines") or die(mysql_error()); 

I get command not allowed error.

I have enabled LOCAL infle on server and still get this error any reason why ?

[seby]

that function is deprecated. you should use mysql_query instead along with mysql_select_db

[Mark_Nordstrom]

the problem is i cant get the data into MYSQL unless i use LOAD DATA LOCAL. I have no clue how i could any other way.

[seby]

make sure you are connected to mysql and have the db selected, try this:

mysql_query("LOAD DATA INFILE '/path/to/file.txt' INTO TABLE stats FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 5 lines");

[Mark_Nordstrom]

nope not working it jsut cant find the file at all.

I attached one of the files that are uploaded. Is there anway to upload the stats on this file without using LOCAL ?

All fields on this are in database.