Print Instructor Labels
| Department |
Number of Instructors |
END;
$query = "SELECT Department from SR_department";
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
$query = "SELECT count(*) from SR_instructor where SR_instructor.Department='$row1[0]'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
$row1[0] |
$row[0] |
END;
}
$query = "SELECT count(*) from SR_instructor";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
Total: |
$row[0] |
Please click on the numbers to view and print labels. 3x10 5160 Address Labels are to be used. Please use
Page Setup to set the margins as the following: Left-0.25, Right-0.25, Top-0.48, Bottom-0.4 before you start printing. |
END;
?>
