Employee: ", $elname, ", ", $efname, "
";
echo "Birth Date: ", $ebdate, "
";
echo "Address: ", $eaddress, "
";
echo "Salary: ", $esalary, "
";
echo "Department: ", $edname, "";
echo "Projects Involved In:
";
$query="SELECT pnumber,pname,hours FROM project,works_on where pno=pnumber and essn=$essn";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num > 0) {
?>
| Project Number |
Project Name |
Hours |
|
|
|
|
";
echo "
";
echo "Dependents:
";
$query="SELECT dependent_name,sex,bdate,relationship FROM dependent where essn=$essn";
$result=mysql_query($query);
$num=mysql_numrows($result);
if ($num > 0) {
?>
| Dependent Name |
Sex |
Birth Date |
Relationship |
|
|
|
|
";
echo "
";
mysql_close();
?>
Return to main page