This is what I got so far:
<?php
$query = "SELECT re_first_name, re_last_name FROM students WHERE re_status_id_fk =3";
$result = mysql_query($query);
if($list=1)
{
while($row = mysql_fetch_assoc($result))
{
echo "<table cellspacing=3 cellpadding=0 border=0><tr><td width=70><b>Name: </b></td><td width=300>";
echo " ".$row[re_first_name]." ". $row[re_last_name]." ";
echo "</td>";
echo "</tr></table>";
}
echo "<br><br>";
}
else{
echo "The script isn't working properly, please try clicking the link again. If you continue to get this message contact your web site administrator.";
echo "<br>";
}
mysql_close();
include ('templates/footer.inc');
ob_end_flush();
exit();
?>