require "db2con.php"; require "common.php3"; $lefthead[0]="Search LyricFind"; $leftbody[0]=$commonsearch; $lefthead[1]="Listings"; $leftbody[1]=$commonlist; print gettop("Newsletter Archive",$lefthead,$leftbody); ?> if ($id=="") { $page=1; $query="select id, name, time from newsletters where id>0 AND site=0 order by id"; $result=mysql_query($query); if (mysql_num_rows($result)==0) {print "No more results were found";} else { print "
Click on an issue to view the content from that mailing.
";
while ($obj=mysql_fetch_object($result)) {
$obj->time=htmlspecialchars($obj->time);
$obj->name=htmlspecialchars($obj->name);
print "id\">$obj->name - $obj->time $obj->name - $obj->time $obj->body
";
}
}
}
else {
$query="select * from newsletters where id=$id and site=0";
$result=mysql_query($query);
$obj=mysql_fetch_object($result);
$obj->time=htmlspecialchars($obj->time);
$obj->name=htmlspecialchars($obj->name);
$obj->body=htmlspecialchars($obj->body);
$obj->body=nl2br($obj->body);
print "