17 |
printf("</HEAD>\n"); |
printf("</HEAD>\n"); |
18 |
|
|
19 |
|
|
20 |
|
// Default access settings |
21 |
|
$sess_time_human = ""; |
22 |
|
$sess_staff_account = ""; |
23 |
|
$sess_staff_id = 0; |
24 |
|
$sess_access_level = 0; |
25 |
|
$sess_access = ""; |
26 |
|
$sess_last_name = ""; |
27 |
|
$sess_first_name = ""; |
28 |
|
|
29 |
|
|
30 |
// Page header |
// Page header |
31 |
require_once ($GLOBAL_ADMIN_HEADER); |
require_once ($GLOBAL_ADMIN_HEADER); |
32 |
|
|
80 |
$rowcount = 0; |
$rowcount = 0; |
81 |
$sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code |
$sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code |
82 |
FROM subject s |
FROM subject s |
83 |
LEFT JOIN sub_coursesub sc using (subject_id) |
LEFT JOIN sub_coursesub sc on s.subject_id = sc.subject_id |
84 |
LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id |
LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id |
85 |
WHERE s.subject_id > 1 |
WHERE s.subject_id > 1 |
86 |
ORDER BY subject"; |
ORDER BY s.subject"; |
87 |
|
|
88 |
// printf("sql was: %s<BR>", $sql); |
$rs = xx_tryquery($sql); |
89 |
|
|
90 |
$rs = xx_query($sql, $con); |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
|
|
|
|
while ($row = xx_fetch_array ($rs)) { |
|
91 |
|
|
92 |
// Increment counter |
// Increment counter |
93 |
$rowcount++; |
$rowcount++; |
94 |
|
|
|
|
|
95 |
// Make every other third row colored |
// Make every other third row colored |
96 |
if ($rowcount % 3 == 0) $color = " class=\"backLight\" "; |
if ($rowcount % 3 == 0) $color = " class=\"backLight\" "; |
97 |
else $color = ""; |
else $color = ""; |
117 |
|
|
118 |
printf("<tr>\n"); |
printf("<tr>\n"); |
119 |
|
|
120 |
if ($subject_id != $last_subject_id ) printf("<td>%s</td>\n", $subject_link); |
if ($subject_id != $last_subject_id) printf("<td>%s</td>\n", $subject_link); |
121 |
else printf("<td> </td>\n"); |
else printf("<td> </td>\n"); |
122 |
|
|
123 |
if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code); |
if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code); |
131 |
|
|
132 |
}; |
}; |
133 |
|
|
134 |
printf("<tr><td colspan=\"2\" class=\"cellPlain\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount); |
printf("<tr><td colspan=\"2\" class=\"backLight\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount); |
135 |
printf("</table>"); |
printf("</table>"); |
136 |
|
|
137 |
// Link to return to admin console |
// Link to return to admin console |