Need help in PHP & Mysql...

date posted 31st January 2003 13:09

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C2C94F.6DB9FCE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_0007_01C2C94F.6DB9FCE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








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

------=_NextPart_000_0007_01C2C94F.6DB9FCE0--