[PHP] Getting email out of a database

[Richard Kurth]

  I am trying to pull all the e-mail address out of a database to be
  able to do a mass send.
  This gets me all the e-mail address and puts a , between them which is what
  I want.

$sql = "SELECT CONCAT(email) AS str_email FROM customers";
                $result = mysql_query($sql);
                 $recip = array();
        while ($myrow = mysql_fetch_array($result)) 
                $recip[] = $myrow["str_email"];
        $recipient_list = implode(", ",$recip);

  I t gives me this list which is what I wanted
[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]

     But now I would like to get the first address in the list into a
     variable and the rest in the list to a second variable Like
     this
    $v1=  [EMAIL PROTECTED]
    $v2=  [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]

    How would I go about this



Best regards,
 Richard  
mailto:[EMAIL PROTECTED]


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