Creating a mass email system

[topflight]

I currently have 4 groups in my database and I want to have it set up so if the admin select one group and type a message in, it will email all the members in that group, but if the admin select ALL members it will email all member. I already have the form made out but I am confused on how to get started on this. Please help.

 

 

Thanks in Advanced!

[topflight]

any help?

[jackpf]

Well, something like this...?

 

$sql = mysql_query("SELECT * FROM table WHERE group='whatever'");
while($fetch = mysql_fetch_array($sql))
{
//Insert stuff into the message table here...
}

[topflight]

I guess not do I just put the email stuff like to from and everything like that between the curly brackets also How can I use the BCC feature?

[jackpf]

Oh right...an actual email; I thought you meant like, your own private messaging system.

 

And yes, that's exactly what you'd do.

 

For more info, check this out.

[redarrow]

what the name off the four groups please.

[topflight]

a

b

c

d

 

[redarrow]

 

Here a grate example i just done for you.

 

Donation page is on the forum ....

 

enjoy.........

<?php

//database connection.

if(isset($_POST['submit'])){

$update_group=trim(mysql_real_escape_string($_POST['update_group']));

$sql="SELECT * FROM what_evaer where group='$update_group'";

$res=mysql_query($sql)or die("There a select problam".mysql_error());

if(mysql_num_rows($res)){


	while($group_data=mysql_fetch_assoc($res)){


		$to = $group_data['group_email_address']; 		



		$mess="bla blaa blaaa blaaa blaaaaaa blaaaaaaaaaaa!";


$message=$mess;

    
$subject = 'This is a email from who_ever.!'; 


$headers = 
        'X-Mailer: PHP/' . phpversion() . "\r\n" .
        "MIME-Version: 1.0\r\n" .
        "Content-Type: text/html; charset=utf-8\r\n" .
        "Content-Transfer-Encoding: 8bit\r\n\r\n";

echo"You have sent email to the current email address:";

if(mail($to, $subject, $message, $headers)){


echo"<br>$to<br>";

exit;
          }
	   }
	    }
             }

echo" <form method='POST' action='{$_SERVER['PHP_SELF']}'>";

echo "<center><select name='update_group'><option value=' '>Selected</option>";

$select_array=array("a","b","c","d");


foreach($select_array as $array_selected){

echo"<option value='$array_selected'>$array_selected</option>";
}

echo"</select><br><br>";



echo "<input type='submit' name='submit' value='Send the update via a group'>";

echo"</center></form>";

?>

[ferret147]

Would there be away of limiting the number of users this sends an email to!

 

For example you tap in your message click submit and it sends to the first 100 email address in the database then you have to click a continue button or something to send to the next 100.

 

Just that if you have say 10,000 people in your database the server will not like that and it may crash.

[redarrow]

Let the code sleep() <<<clue.

 

http://uk.php.net/sleep