Re: FN-FORUM Need help in PHP & Mysql...

date posted 31st January 2003 13:46

I'm assuming you are running the PHP script on a web server in which case the statement is looking for the file on the c: drive of web server.

Peter
(Look after your clients, or someone else will)
www.peterdrayton.co.uk


the LOCAL command means local to the >
> From: "danish" [EMAIL REMOVED]
> Date: Fri 31/Jan/2003 12:37 GMT
> To: [EMAIL REMOVED]
> Subject: FN-FORUM Need help in PHP & Mysql...
>
> Hi,
> I have two questions.
>
> 1- Actually I m reading a text file using PHP script. I wanna know that is their any function or way in PHP to directly approach to specific line in text file for reading.
>
> 2- I m connecting to FTP server using telnet, after login I then connect to Mysql server. There I used a command to read text file & insert its data to specific table and the text file is on my personal PC's desktop.
>
> " load data local infile 'c:\data.txt' into table danish "
>
> After using this command Mysql shows an error which is something like that " File not found ". Now I dont understand that why this error is occuring because the text file is on my C drive & the version of Mysql is greater than 3.23 & this version supports "LOCAL" option in Load Data command.
>
> Regards
> Danish Umer
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003
>
>


__________________________________________________________________________
Freeserve AnyTime - Go online whenever you want for just £6.99 a month for
your first 3 months, that's HALF PRICE! And then it's just £13.99 a month
after that.

For more information visit http://www.freeserve.com/time/ or call free on
0800 970 8890