Hi Richard,
I *always* get this word wrong, but here goes.... You need to
"concantenate" (grimace), which means (simply) "add to" to the variable,
using .=
Modify your code slightly:
<?
$recipient = "";
$result = @mysql_query($sql);
$num_rows = mysql_num_rows($result);
while($myrow = mysql_fetch_array($result)) {
$email = $myrow['email'];
$recipient .= $email . ",";
}
?>
Notice the .= before $recipient = $email.... ?
Also why, is the $num_rows in there? It's not being used for anything. If
you might have blank emails in there, you could make good use of the num
rows.....
<?
$recipient = "";
$result = @mysql_query($sql);
$num_rows = mysql_num_rows($result);
$x = 0;
while($myrow = mysql_fetch_array($result)) {
$email = $myrow['email'];
if (isset($email)) {
$recipient .= $email . ",";
$x++;
}
}
echo "Email sent to " . $x . " number of people, out of " . $num_rows . "
residing in the database.";
?>
Hope that helps,
James.
"Richard Kurth" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> 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]
>
--
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]