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

2001-08-16 Thread Yeong CN
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

2001-08-16 Thread Yeong CN
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)