Don't forget you can just as easily replace the ; with any character you may
be separating the email addresses using (for instance a comma)

Ryan

-----Original Message-----
From: Chris Hobbs [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 27, 2001 11:16 PM
To: PHP-DB List
Subject: Re: [PHP-DB] CSV TO MYSQL

How about this:

<?php
$emailstring = "[EMAIL PROTECTED];[EMAIL PROTECTED];[EMAIL PROTECTED]";
@emails = explode(";", $emailstring);
foreach($emails as $email) {
     echo "INSERT INTO news VALUES('$email');\n";
}
?>

Rupert wrote:

> 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
> 
> 
> 
> 
> 


-- 
Chris Hobbs       Silver Valley Unified School District
Head geek:              Technology Services Coordinator
webmaster:   http://www.silvervalley.k12.ca.us/~chobbs/
postmaster:               [EMAIL PROTECTED]


-- 
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]

-- 
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]

Reply via email to