mass mailing

[Sharif]

Would this work if I were trying to email a bunch of users at once?

$ids = implode(",", $_POST['activate_users']); 

$sql = "SELECT email FROM table WHERE userid IN ($ids)";
$query = mysql_query($sql);
$row = mysql_fetch_array($query);

$go = implode(",", $row['email']);

mail($go, $sub,$mesg, $header);

[HalfaBee]

This will only send to 1 person.
You need to have a loop.

ehile( $row = mysql_fetch_array($query) ) {
    $go .= ",". $row['email'];
}
$go = preg_replace( '/^,/','',$go );

Of course this won't work if my email addr is in your database 😃

Halfabee

[Sharif]

Why is preg_replace() being used? And why does $go add on to something ($go .=)?

[Sharif]

Ok I am trying hard but am having no luck:

$ids = implode(",", $_POST['activate_users']); 
$emails = "SELECT email FROM users WHERE userid IN($ids)";
$query2 = mysql_query($emails) or die(sql_error());
while($row2 = mysql_fetch_array($query2))
{
     $e = $row2['email'];
}

echo explode(",", $e); 

Just trying to get a list of all email addresses but it doesn't work...

[LordShryku]

$ids = implode("','", $_POST['activate_users']);  

$emails = "SELECT email FROM users WHERE userid IN('".$ids."')";
$query2 = mysql_query($emails) or die(sql_error());
$i=0;
while($row2 = mysql_fetch_array($query2)) 
{ 
   if($i==0) {
      $e = $row2['email']; 
   }
   else {
      $e .= ", ".$row2['email'];
   }
   $i++;
} 
echo $e;

Try that. Need single quotes

[Sharif]

Can you explain why $i = 0 and then $i++? And why $e .=?

[LordShryku]

Because you're creating a string. When $i == 0, it starts the string. At the end of every loop, you increment $i. So on the next go around, $i != 0, so instead of creating the string, you add to it (that's what .= does)

[Sharif]

OOH, it sort of makes sense now. Anyways so now I can do:

mail($e, $sub,$mes,$from);

[HalfaBee]

Originally posted by Sharif
Why is preg_replace() being used? And why does $go add on to something ($go .=)?

I used preg_replace() to strip off the first ,

$go .= adds a string to the end of $go

HalfaBee