<?INCLUDE 'd.php';
$title=$_GET['title'];






$sel=mysql_query("select * from news where title='$title'") or die("no");
$n1=mysql_num_rows($sel);
$i1=0;


while($i1<$n1)
{
$news=mysql_result($sel,$i1,"news");
$title=mysql_result($sel,$i1, "title");

$i1++;
}








$sel=mysql_query("select * from newemail");
$n=mysql_num_rows($sel);
$i=0;
while($i<$n)
{
$to=mysql_result($sel,$i,"email");
$name=mysql_result($sel,$i,"name");

$message=" Dear $name <br><br>

include 'newsletter.html'";





// To send HTML mail, the Content-type header must be set
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";


$headers .= 'From:mysite.com <customer@mysite.com>' . "\r\n";

$subject="News letter from mysite";

mail($to, $subject, $message, $headers);
print "Newsletter is sent to $to";print "<br>";
$i++;
}