I think you want $recipient .= $myrow["email"] . ","; although that does leave a comma at the end. You can just knock the last character off the end or , more elegantly, $recipient = array(); while ($myrow = mysql_fetch_array($result)) $recipient[] = $myrow["email"]; $recipient_list = implode(",", $recipient); Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html > -----Original Message----- > From: Richard Kurth [mailto:[EMAIL PROTECTED]] > Sent: 15 May 2001 09:16 > To: [EMAIL PROTECTED] > Subject: Needing help hear > > > > I am trying to pull all the e-mail out of the database and put them > in a format like this [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] > this is what I have now but I don't seam to be going in the right > direction. Could somebody give me a hint > > $sql = "SELECT email FROM customers"; > $result = mysql_query($sql); > $num_rows = mysql_num_rows($result); > > while ($myrow = mysql_fetch_array($result)){ > > $recipient=$myrow["email"] . ","; > } > > > > > > > > > > > > > > > > > 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]