Project: ", $pname, "
";
echo "Project Location: ", $ploc, "
";
echo "Controlling Department: ", $pdname, "";
echo "Employees working in project:
";
$query="SELECT ssn,lname,fname,hours FROM employee,works_on where pno=$pnum and essn=ssn";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num > 0) {
?>
| Employee SSN |
Employee Last Name |
Employee First Name |
Hours |
|
|
|
|
|
";
echo "
";
mysql_close();
?>
Return to main page