can a while loop read text file line by line and add the entry to MySQL table

[amaximo]

I am new to this sql stuff and could use a hand.

I have a list of emails that I need to enter into my data base.

-can a while loop read text file line by line and add the entry to MySQL table?

---

-this works to insert one row at a time when I change the values by hand but thats to slow

INSERT INTO mail ( id , fname , lname , email )
VALUES (
'', Brian , Smith , '[e-mail]'
);

---

I want to read the list of emails and names and put them into my database with a script. Can it be done? and how?

---

this is a sample of what my text file list looks like :

Brian Smith [e-mail]
Kelly Green [e-mail]
Bob Brown [e-mail]

Thanks for your help.

[TheIceman5]

yeah its easy, just search round youll find answers and things to tack together to do what u want.

AND DONT DOUBLE POST IT PISSES PEOPLE OFF!!!

[amaximo]

The first time I posted I got a blank page after I didn't think it worked. I deleted the other post.

I have been googling for the answer for a couple of hours, no luck.

What should I search for to answer my question?

[jasonn]

I think file() will do it for you.

http://php.net/file

Then go through array.

jasonn.