
$selectSQL=("SELECT DISPLAY_NAME FROM brunswic_bbpo.patron where LEVEL='Diamond' and YEAR='2008' and PAID='Y' and DELETED='N' GROUP BY LAST_NAME ASC");
$result=mysql_query($selectSQL);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
echo $display_name=mysql_result($result,$i,"DISPLAY_NAME");
echo "
";
$i++;
}
?>

$selectSQL=("SELECT DISPLAY_NAME FROM brunswic_bbpo.patron where LEVEL='Platinum' and YEAR='2008' and PAID='Y' and DELETED='N' GROUP BY LAST_NAME ASC");
$result=mysql_query($selectSQL);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
echo $display_name=mysql_result($result,$i,"DISPLAY_NAME");
echo "
";
$i++;
}
?>

$selectSQL=("SELECT DISPLAY_NAME FROM brunswic_bbpo.patron where LEVEL='Gold' and YEAR='2008' and PAID='Y' and DELETED='N' GROUP BY LAST_NAME ASC");
$result=mysql_query($selectSQL);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
echo $display_name=mysql_result($result,$i,"DISPLAY_NAME");
echo "
";
$i++;
}
?>

$selectSQL=("SELECT DISPLAY_NAME FROM brunswic_bbpo.patron where LEVEL='Silver' and YEAR='2008' and PAID='Y' and DELETED='N' GROUP BY LAST_NAME ASC");
$result=mysql_query($selectSQL);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
echo $display_name=mysql_result($result,$i,"DISPLAY_NAME");
echo "
";
$i++;
}
?>

$selectSQL=("SELECT DISPLAY_NAME FROM brunswic_bbpo.patron where LEVEL='Friends' and YEAR='2008' and PAID='Y' and DELETED='N' GROUP BY LAST_NAME ASC");
$result=mysql_query($selectSQL);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
echo $display_name=mysql_result($result,$i,"DISPLAY_NAME");
echo "
";
$i++;
}
mysql_close($strDB);
?>