I have a newsletter system which works perfectly, except when I try to send a newsletter to the users that have signed up, it does not send.
here is the code for my send_letter.php page
<?php
if(isset($_SESSION["username"]))
{
include "left.php";
print "</td>";
print "<td valign='top' width=70%>";
print "<table class='maintable'><tr class='headline'><td><center>Send Newsletter</center></td></tr>";
print "<tr class='mainrow'><td>";
if(isset($_POST['submit']))
{
$nletter=$_POST['nletter'];
$subject=$_POST['subject'];
$nletter=stripslashes($nletter);
$subject=stripslashes($subject);
$lists=$_POST['lists'];
$nletter=str_replace("rn","<br>",$nletter);
if($lists==0)
{
$selectmails="SELECT * from email_list where validated='1' and emailed='0'";
}
else
{
$selectmails="SELECT * from email_list where validated='1' and emailed='0' and list_id='$lists'";
}
$selectmails2=mysql_query($selectmails) or die("Could not select mails");
while($selectmails3=mysql_fetch_array($selectmails2))
{
$headers = "From: $yourmail \r\n";
$headers.= "Content-Type: text/html; charset=ISO-8859-1 ";
$headers .= "MIME-Version: 1.0 ";
mail("$selectmails3[address]","$subject","$nletter<br><br><br>Newsletter power by Phoebus)",$headers);
$setassend="update email_list set emailed='1' where email_id='$selectmails3[email_id]'";
mysql_query($setassend) or die("Could not set as send");
}
print "Newsletter Sent";
}
else
{
print "<form action='send_letter.php' method='post'>";
print "Subject:<br>";
print "<input type='text' name='subject' size='20'><br>";
print "List to send to:<br>";
print "<select name='lists'>";
$getlists="SELECT * from newsletters";
$getlists2=mysql_query($getlists) or die("Could not get lists");
print "<option value='0'>All</option>";
while($getlists3=mysql_fetch_array($getlists2))
{
print "<option value='$getlists3[newsletter_id]'>$getlists3[newsletter_name]</option>";
}
print "</select><br>";
print "Letter to send:<br>";
print "<textarea name='nletter' rows='8' cols='60' id='7'></textarea><br>";
print '<script language="JavaScript">';
print "generate_wysiwyg('7')";
print "</script>";
print "<input type='submit' name='submit' value='submit'></form>";
}
print "</td></tr></table>";
}
?>
any help would be much appreciated. thanks
