[SOLVED] E-MAIL problems

[topflight]

I have this mass email script but it is not working please help:

<?php
include 'db.php'; 
$message = $_POST['message'];
$subject = $_POST['subject'];
if(isset($_POST['submit'])){
if((!$message | !$subject)){
echo'You are missing some required information please go back and fill out all the required information';
} else {

$sql = mysql_query("SELECT * FROM members ORDER BY 'id' ASC");
$result = mysql_fetch_assoc($sql);
$bcc = $result["email"];
for ($index=0; $index < count($bcc); $index++)
  { 


$from = 'email';
$to = 'email';
$header .= "Bcc: ".$bcc."\r\n"; 
$headers .= 'From: <[email protected]>' . "\r\n";

mail($to,$subject, $message, $headers);
}}}?>

[soak]

You are never looping the results returned:

 

<?php
include 'db.php'; 
$message = $_POST['message'];
$subject = $_POST['subject'];
if(isset($_POST['submit'])){
    if((!$message | !$subject)){
        echo'You are missing some required information please go back and fill out all the required information';
    } else {

        $sql = mysql_query("SELECT email FROM members ORDER BY `id` ASC");
        if (mysql_num_rows($sql)) {
            $bcc = array();
            while ($result = mysql_fetch_assoc($sql)) {
                $bcc[] = $result["email"];
            }
            $from = 'email';
            $to = 'email';
            $header = "Bcc: ".implode("\r\n", $bcc)."\r\n" 
            $header .= 'From: <[email protected]>' . "\r\n";

            mail($to, $subject, $message, $header);
        }
    }
}
?>

 

[topflight]

when I used that code all the emails were display in the message and the message displayed at the bottom.

[soak]

Sorry, my mistake, the bcc emails should be seperated by a comma not a newline:

 

<?php
include 'db.php'; 
$message = $_POST['message'];
$subject = $_POST['subject'];
if(isset($_POST['submit'])){
    if((!$message | !$subject)){
        echo'You are missing some required information please go back and fill out all the required information';
    } else {

        $sql = mysql_query("SELECT email FROM members ORDER BY `id` ASC");
        if (mysql_num_rows($sql)) {
            $bcc = array();
            while ($result = mysql_fetch_assoc($sql)) {
                $bcc[] = $result["email"];
            }
            $from = 'email';
            $to = 'email';
            $header = "Bcc: ".implode(", ", $bcc)."\r\n" 
            $header .= 'From: <[email protected]>' . "\r\n";

            mail($to, $subject, $message, $header);
        }
    }
}
?>

[topflight]

I am using that code and it not sending to all the emails in the database. for the $to should I create an another account like [email protected] and for $from should it be [email protected] . Because that code is not sending to no one in the database.

[topflight]

it works thanks, just had to wait for a min.

[soak]

I'm pretty sure there's a limit to the number of bcc's you can have (poss 250?). Personally I'd use a pre built system like phpmailer that handles this sort of thing for you.