thank for reply me. But i think the problem is not in the .csv file because today when
I test it with netscape..it ok...
it return the message like that :
LOAD DATA LOCAL INFILE '/TEMP/phpB080AVGU' INTO TABLE
purchase FIELDS TERMINATED BY ','
(purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)
Successful.
but when I test with IE,it fail and return the message like that,
Error : LOAD DATA LOCAL INFILE 'C:\prchase3.csv' INTO TABLE
purchase FIELDS TERMINATED BY ','
(purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)
File 'c:purchase3.csv' not found (Errcode: 2)
the difererent is between the file reading by IE 5.5 and Netscape 4.7 there...seem
like IE reading file in C:\purchase3.csv and netscape reading file in
/temp/phpB080AVGU ....
but 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, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote:
> 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);
> $result=mysql_query($sql_query);
> $error_message=mysql_error();
> if(!$result)
> {
> echo"Error : $sql_query<br><p>";
> echo"$error_message";
> }
> else if($result)
> {
> echo"$sql_query<br><p>";
> echo"successful";
> }
>
> When I try to run the script in localhost, it is work.But when I try in the \
> server,it can't work and return the error message like that :
> Error : LOAD DATA LOCAL INFILE 'C:\\purchase3.csv' INTO TABLE purchase FIELDS \
> TERMINATED BY ',' (purchase_order,job_no,username,model,quantity,due_date,sent_date,
> courier_service,remark)
> File 'C:\purchase3.csv' not found (Errcode: 2)
>
>
> I think it maybe the backsplashes that make the error occur..
>
> so I change the script like that :
>
> $sql_query=stripslashes($sql_query);
>
> But it still return the error message like that :
>
> Error : LOAD DATA LOCAL INFILE 'C:\purchase3.csv' INTO TABLE purchase FIELDS
> TERMINATED BY ',' (purchase_order,job_no,username,model,quantity,due_date,sent_date,
> courier_service,remark)
> File 'C:purchase3.csv' not found (Errcode: 2)
>
>
> What happen actually...hope that somebody can help me. Thanks.
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
