emailing users

[runnerjp]

i store my users emails on signup in my db... but i was wondering how i could send 1 email to them all ?? would the names have to be sepreated by , or anything of sort?

[zq29]

Yes.

[runnerjp]

u mean yes seperated by a ,... is there a limit to amount of users it can be sent too>

[runnerjp]

bmp

[DeanWhitehouse]

yes and not technically, there is no limit but the script may time out if you use standard mail to send one emails to lots of people.

[runnerjp]

ok you may know what my next question will be...

 

so basicly i have to loop the emails and then send it via what (whats other then standerd mail ??)

[DeanWhitehouse]

I think phpmailer would be a good choice, and loop through each recipicent and send the email, or i think it is called PEAR::Mail or similar.

 

http://uk.php.net/function.mail

[runnerjp]

ok would it go something like

<?php

mysql_select_array()
while {
if (isset($_REQUEST['email']))
//if "email" is filled out, send email
  {
  //send email
  $email = $useremail  //taken from db ;
  $subject = $_REQUEST['subject'] ;
  $message = $_REQUEST['message'] ;
  mail( "[email protected]", "Subject: $subject",
  $message, "From: $email" );
  echo "email sent";
  }}
else
//if "email" is not filled out, display the form
  {
  echo "<form method='post' action='mailform.php'>
   Subject: <input name='subject' type='text' /><br />
  Message:<br />
  <textarea name='message' rows='15' cols='40'>
  </textarea><br />
  <input type='submit' />
  </form>";
  }
?>

[DeanWhitehouse]

no , do something like

for($to as $to1)

{

mail( $to1, "Subject: $subject",

  $message, "From: $email" );

}

 

that will be for multiple emails

[runnerjp]

ok... so wuld it be at the top

 

<?php

    $sql = "SELECT email FROM users";

 

    $data = mysql_query( $sql ) or die( "Could not get threads" );

 

    while ( $data2 = mysql_fetch_array( $data ) )

{

$to = $data2;

}

?>

 

then that would be the for($to as $to1)

[runnerjp]

bmp

[BlueSkyIS]

yes.

[runnerjp]

what is the $to1 tho

[DeanWhitehouse]

soz that should be

foreach($to as $to1)

{

mail($to1, "Subject: $subject",

  $message, "From: $email" );

}

 

and the $to1 , is the var that is created for each email.