I would very much like if someone could look at this piece of code and tell me what I am doing wrong? I want send out a Newsletter to all subscribers on the Newsletter subscriber list.
I have been test this piece code and I keep getting the wrong email address in the send To: address is incorrect.
For example:
Let say I have four email addresses in my newsletter list as follows:
jybwalker@netscape.net
zeb_sanders2000@yahoo.com
zsand@hotmail.com
Example: This what I received at
zsand@hotmail.com
Date: Wed, 16 Jun 2004 01:26:09 -05
From: "demo inc."<info@nuevera.com>
To:
zeb_sanders2000@yahoo.com This is wrong ...It should say
zsand@hotmail.com
Subject: test # 33
This is test # 33 on June 14, 2004---
demo.nuevera.com newsletter
For some reason it is putting this address
zsand@hotmail.com
on all of the emails.
Each email is sent to the right address but it put the third email address from the newsletter list above as the recipient address.
Can some help me please?
I have looked at several email scripts with loops and found on answers.
Please help if you can.
Thanks
Zeb
Here is the Code:
///////////////////
// Begin Newsletter
///////////////////
if($ax=="send")
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: send</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
$result = MySQLQuery("select * from php_newsletter", $QueryError_Email, $QueryError_Browser);
$subs=mysql_num_rows($result);
echo "<span class=label-text>There are $subs subscriber(s) to your newsletter.</span>";
echo "<form id=\"newsletter\" action=\"".$_SERVER["PHP_SELF"]."?ax=sendmail\" method=\"post\">
<table border=\"0\" width=\"100%\" cellspacing=\"2\" cellpadding=\"0\">
<tr><td class=label-text>Subject:<br /><input type=\"text\" name=\"subject\" class=input-textbox size=\"70\"></td></tr>
<tr><td class=label-text>Message:<br/><textarea name=\"message\" rows=\"20\" class=input-textarea cols=\"70\"></textarea></td></tr>
<tr><td><input class=input-button type=\"submit\" name=\"submit\" value=\"Send\"></td></tr>
</table>
</form>";
}
else if($ax=="sublist")
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Subscriber list</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
$result = MySQLQuery("select * from php_newsletter order by email asc", $QueryError_Email, $QueryError_Browser);
if(mysql_num_rows($result))
{
echo "";
while($row=mysql_fetch_array($result))
{
$id=$row["id"];
$email=$row["email"];
echo "<table cellspacing=1 width=100%><tr><td width=80% class=body-bg4><span class=main-text><li><a class=menu-link-1 href=\"mailto:$email\">$email</a></td><td class=body-bg4> [ <a class=menu-link-1 href=\"".$_SERVER["PHP_SELF"]."?ax=dsub&id=$id\">Delete</a> ]</span></td></tr></table>";
}
}
else
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Subscriber list</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> There are currently no subscribers to your newletter.</span>";
}
}
else if($ax=="dsub")
{
$v=$_GET["v"];
if($v=="y")
{
$result=MySQLQuery("delete from php_newsletter where id=$id",$QueryError_Email,$QueryError_Browser);
if ($result)
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Subscriber list</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> Subscriber deleted</span>";
header("Location: ".$_SERVER["PHP_SELF"]."?ax=sublist");
}
else
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Subscriber list</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> $alert_image Error Deleting Subscriber</span>";
}
}
else
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Subscriber list</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> $alert_image Are you sure? If you want to delete this subscriber, <a class=menu-link-2 href=\"".$_SERVER["PHP_SELF"]."?ax=dsub&id=$id&v=y\">[ click here ]</a>.</span>";
}
}
else if($ax=="sendmail")
{
$subject=$_POST["subject"];
$message=$_POST["message"];
if($subject!="" && $message!="")
{
$subject=StripSlashes($subject);
$message=StripSlashes($message);
$result=MySQLQuery("select email from php_newsletter",$QueryError_Email,$QueryError_Brow ser);
$comma_count=1;
$bcc_list="";
while($row = mysql_fetch_array($result))
{
$email=$row["email"];
if($comma_count > 1){$bcc_list.=",";}
$bcc_list.=$email;
$comma_count=$comma_count + 1;
}
$top="<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">
<html>
<head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\"></head>
<body>";
$footer="---<br> $domain newsletter <br>---</p></body></html>";
$whole_message=$top.$message.$footer;
mail ("Member","$subject","$whole_message","From: $sammod_client<$client_email>\nMIME-Version: 1.0\nContent-type: text/html; charset=iso-8859-1\nBcc: $bcc_list\n");
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Send message</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> Your message has been sent!</span>";
}
else
{
echo "$menu\n<table cellspacing=0 width=100% class=body-bg1><tr><td class=page-header colspan=2> Newsletter: Send message</td><td class=menu-link align=right>$newsletter_menu</td></tr></table>";
echo "<span class=label-text><br> $alert_image You didn't fill out the whole form. <a class=menu-link-2 href=javascript
:history.go(-1)>[Go Back]</span>\n";
}
}
/////////////////
// End Newsletter
/////////////////
Threaded Mode
