How do I add a list of emails to my database?
Posted: Wed Oct 29, 2003 9:04 am
I am new to this php/sql stuff and could use a hand.
I have a list of emails that I need to enter into my data base.
-can a script read a text file line by line and add the entries to a 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 , 'Brian@mail.com'
);
------------
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 Brian@mail.com
Kelly Green Kelly@mail.com
Bob Brown Bob@mail.com
Thanks for your help.
I have a list of emails that I need to enter into my data base.
-can a script read a text file line by line and add the entries to a 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 , 'Brian@mail.com'
);
------------
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 Brian@mail.com
Kelly Green Kelly@mail.com
Bob Brown Bob@mail.com
Thanks for your help.