Re: [PHP-DB] CSV TO MYSQL

2001-08-27 Thread Chris Hobbs
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

RE: [PHP-DB] CSV TO MYSQL

2001-08-27 Thread Ryan Marrs
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

Re: [PHP-DB] CSV TO MYSQL

2001-08-27 Thread Chris Hobbs
Are you running php3 or php4? 'foreach' was added in php4, which might explain your error. If you're running php3, try replacing that line with: while(list($key,$email) = each($emails)) { I don't know if this works in php3 or not, but would be worth a shot. Rupert L. Hussey wrote: Hi Chris