Ok, this is my issue - hope someone can help. Suppose I also need to get
this out of the way too - I am a Newbie (god..I hate that word...but it's
true.....grin!)
Anyway, I have a list of email address that I want to dump into a database
called (news) - eg.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
etc..
I separated them with (;'s) like so - [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; etc..
(I suppose I could use commas instead - no prob there)
This is what I want to accomplish:
Each email address is a separate entry that needs to be downloaded into the
database.
Just like this:
# --------------------------------------------------------
#
# Table structure for table 'news'
#
CREATE TABLE news (
email char(255) NOT NULL,
PRIMARY KEY (email),
UNIQUE email (email)
);
#
# Dumping data for table 'news'
#
INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
INSERT INTO news VALUES ( '[EMAIL PROTECTED]');
INSERT INTO news VALUES ( 'etc..');
------------------------------------------------------------
I have a script that gets me to this point:
INSERT INTO news VALUES (,"[EMAIL PROTECTED]"," [EMAIL PROTECTED]","
[EMAIL PROTECTED]","[EMAIL PROTECTED]","etc..");
But that is not what I want. I can attach the script for analysis or if
anyone has a better idea. I would appreciated it very
much. Thanks..
Rupert
--
PHP Database 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]