$query = "SELECT * FROM faculty where group1='Principal'";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo " ";
}
else
{
echo "";
echo "| Principal | ";
while(list($Lname,$qualification,$group1,$designation,$briefinfo,$id, $name) = mysql_fetch_array($result))
{ echo "| ";
?>
| "; echo $qualification; echo " | "; echo $designation;?>
|
}
echo " ";
}
echo " ";
$query = "SELECT * FROM faculty where group1='Faculty'";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo " ";
}
else
{
echo "";
echo "| Faculty | ";
while(list($Lname,$qualification,$group1,$designation,$briefinfo,$id, $name) = mysql_fetch_array($result))
{ echo "| ";
?>
| "; echo $qualification; echo " | "; echo $designation;?>
|
}
echo " ";
}
echo " ";
$query = "SELECT * FROM faculty where group1='Guest Faculty'";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo " ";
}
else
{
echo "";
echo "| Guest Faculty | ";
while(list($Lname,$qualification,$group1,$designation,$briefinfo,$id, $name) = mysql_fetch_array($result))
{ echo "| ";
?>
| "; echo $qualification; echo " | "; echo $designation;?>
|
}
echo " ";
}
echo " ";
$query = "SELECT * FROM faculty where group1='Support Staff'";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo " ";
}
else
{
echo "";
echo "| Support Staff | ";
while(list($Lname,$qualification,$group1,$designation,$briefinfo,$id, $name) = mysql_fetch_array($result))
{ echo "| ";
?>
| "; echo $qualification; echo " | "; echo $designation;?>
|
}
echo " ";
}
?> |