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]
