$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++; }