|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
June 14th, 2004, 02:42 AM
|
|||
|
|||
|
send email to multiple recipient
Hi guys,
I am trying to send out an email to all the emails i got in my db.. this is the code i wrote.. the code looks fine to me... i can receive the email but the content is keep on looping.. my first email got a copy of the content, second email got two copies of duplicated content in the same email, third one with three duplicated copies and so on... for instace : 1st email : ==================== Personal Information ==================== 2nd email : ==================== Personal Information ==================== ==================== Personal Information ==================== 3rd email ==================== Personal Information ==================== ==================== Personal Information ==================== ==================== Personal Information ==================== and so on... how could i make the code only send one copy of the content to all email addresses i have in my db ??? like : ==================== Personal Information ==================== only?? please advise.. Code:
include("listconfig.php");
$web_add = "travel";
$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
$query = "SELECT * FROM listsubscribers WHERE web_add='$web_add'";
$result = mysql_db_query($dbname, $query) or die (mysql_error());
while($row = mysql_fetch_array($result))
{
$to = "{$row['email']}\r\n";
//$from= "From: $name < $email >\r\n";
$from= "From: testing while< myemail >\r\n";
$subject ="$name - online shopping order\r\n";
$contents .="
====================
Personal Information
====================
";
mail($to,$subject,$contents,$from);
if(mail)
{
echo ' email is sent';
echo "<br>".$row['email']."<br>";
}
} // close while loop
thank you...
|
|
#2
June 14th, 2004, 06:43 AM
|
||||
|
||||
|
At the beginning of the loop (just inside the while statement), you need to reset $contents to blank. Or just use the = operator rather than the .= operator when you're setting $contents in the first place.
__________________
Please don't PM me asking for solutions outside the scope of a thread. Keeping all responses in a thread stands to help others who come along later, which is after all what this forum's all about.
|
|
| Viewing: Dev Articles Community Forums > Programming > PHP Development > send email to multiple recipient |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
