$dbcon=mysql_connect("localhost","a0000993","itioni54");
mysql_select_db("a0000993");
$sql = 'SELECT * FROM `alumni` WHERE `auth` = CONVERT(_utf8 \'YES\' USING latin1) COLLATE latin1_swedish_ci LIMIT 0, 30 ';
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
if($nrows != 0)
{
print "
If any items need to be removed, Please email Goalpost@MSN.COM
|
ALUMNI MESSAGES
|
| Name / Message | Years | E-Mail Address |
|
\n";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
print "| " . $row["name"];
print " | " . $row["years"];
print " | " . $row["email"];
print "\n";
print " |
| " . $row["comments"];
print " |
|
\n";
}
print "