Department: ", $dname;
echo "Manager: ", $mlname, ", ", $mfname, "";
echo "Manager Start Date: ", $mstart;
echo "
Department Locations:
";
$query="SELECT dlocation FROM dept_locations where dnumber=$dno";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$dloc=mysql_result($result,$i,"dlocation");
echo $dloc, "
\n";
$i++;
}
echo "Employees:
";
$query="SELECT ssn,lname,fname FROM employee where dno=$dno";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
| Employee SSN |
Last Name |
First Name |
|
|
|
|
Projects:";
$query="SELECT pnumber,pname,plocation FROM project where dnum=$dno";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>