$bm = mysql_query("SELECT * FROM isis_students WHERE FirstName = {$first} AND LastName = {$last}");
$lm = mysql_query("SELECT * FROM isis_students WHERE LastName = {$last}");
$fm = mysql_query("SELECT * FROM isis_students WHERE FirstName = {$first}");
echo "
Search Results:
";
$blc = 1;
$bmn = mysql_num_rows($bm);
while($blc <= $bmn) {
$cn = mysql_fetch_assoc($bm);
echo $cn['LastName'].", ".$cn['FirstName']." (".$cn['StudentID'].")
";
$blc++;
}
$llc = 1;
$lmn = mysql_num_rows($lm);
while($llc <= $lmn) {
$cn = mysql_fetch_assoc($lm);
echo $cn['LastName'].", ".$cn['FirstName']." (".$cn['StudentID'].")
";
$llc++;
}
$flc = 1;
$fmn = mysql_num_rows($fm);
while($flc <= $fmn) {
$cn = mysql_fetch_assoc($fm);
echo $cn['LastName'].", ".$cn['FirstName']." (".$cn['StudentID'].")
";
$flc++;
}