Emailing Multiple Users From MySQL Table??

[tristan_guimond]

Ok, i am VERY new to PHP and am trying to create a page where a user can write and email through a form and send it to all users in my table. I have been able to get the form for sigle emails working fine which lists all of the email addresses in a drop down menu and the user is able to select one and send.

My Table is structured like so -

MySQL table with id, address and name columns.

My Question is can i use mysql_fecth_array() to get all addresses and send? And if so how?

Thanks a million if anyone can help.

Tristan

[swallace]

Here's a piece of code that I use, but it can be easily modified...

$query= "SELECT Email FROM Users";
$result= mysql_query($query);

while ($row= mysql_fetch_array($result)){
$send_to = $send_to. $row[Email ].", ";
}

// format the string for the mail() function
$length = strlen($send_to);
$send_to = substr($send_to, 0, ($length)-2);

mail($send_to, ....);

I guess it's one way of doing it...

[weekender]

this method emails everyone at once, so the 'to' header will show "name1, name2, name3" and everyone who gets the email will see everyone else's address.

to send each user an individual email, move the email section of the code into the while function, like so...

$query= "SELECT Email FROM Users";
$result= mysql_query($query);

while ($row= mysql_fetch_array($result)){
$send_to = $send_to. $row[Email ].", ";
// format the string for the mail() function
$length = strlen($send_to);
$send_to = substr($send_to, 0, ($length)-2);

mail($send_to, ....);
}

[swallace]

I forgot about that bit...my app is an internal one, so it's no bother seeing other addresses :rolleyes:

[tristan_guimond]

Problem solved thanks very much..