[PHP] Re: Errcode: 2 when running LOAD DATA LOCAL INFILE on server

ut the true path of file is locate in c:\purchase3.csv...why this will happen? So I think the problem is occur on the variable $textfile that I defined...can some body help me..thanks... >Post a couple of lines from your data file. Does .csv insist on all >values single quoted? On Thu

[PHP] Errcode: 2 when running LOAD DATA LOCAL INFILE on server

Hi. This is the script I write to upload a .csv file into my online mysql database : $sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO TABLE purchase FIELDS TERMINATED BY ',' (purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)"; $sql_query=($sql_query);

[PHP] Errcode: 2 when running LOAD DATA LOCAL INFILE on server

Hi. This is the script I write to upload a .csv file into my online mysql database : $sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO TABLE purchase FIELDS TERMINATED BY ',' (purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)"; $sql_query=($sql_query)

[PHP] How to add an excel file directly to MySQL database using PHP?

How can I add an excel file with *.xls extension directly into MySQL database..is it possible to do or I need to convert it into *.csv format or *.txt format first? Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- PHP General Mailing List (http://www.php.n