query("SELECT * FROM school_class,school");
if($result) {
while ( $row = $result->fetch_assoc() ){
// echo 'no code is found';
if ($row['specific_classCode'] == $code){
echo "Student";
echo "
";
echo "class: ".$row['class_name']."";
}
else if ($row['specific_staffCode'] == $code){
echo "Teachers";
}
else{
echo "the code is invalid";
}
}
}
$conn->close();
?>