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 |
|
|
52 |
if(isset($libsession) && $sess_access_level >= 20) { |
if(isset($libsession) && $sess_access_level >= 20) { |
53 |
|
|
54 |
// Fetch the mastersubject descr. field |
// Fetch the mastersubject descr. field |
55 |
$mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject"); |
$mastersubject = lookupField("mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject"); |
56 |
|
|
57 |
printf("<center>\n"); |
printf("<center>\n"); |
58 |
printf("<h3>Master Subject '%s' (#%d) contains the following Subjects:</h3>", $mastersubject, $mastersubject_id); |
printf("<h3>Master Subject '%s' (#%d) contains the following Subjects:</h3>", $mastersubject, $mastersubject_id); |
84 |
|
|
85 |
// printf("sql was: %s<BR>\n", $sql); |
// printf("sql was: %s<BR>\n", $sql); |
86 |
|
|
87 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
88 |
|
|
89 |
// Initialize counter |
// Initialize counter |
90 |
$rowcount = 0; |
$rowcount = 0; |
91 |
|
|
92 |
// Cycle through the result set |
// Cycle through the result set |
93 |
while ( $row = mysql_fetch_array ( $rs ) ) { |
while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
94 |
$subject_id = Trim($row["subject_id"]); |
$subject_id = Trim($row["subject_id"]); |
95 |
$subject = Trim($row["subject"]); |
$subject = Trim($row["subject"]); |
96 |
|
|
143 |
|
|
144 |
// printf("sql was: %s<BR>\n", $sql); |
// printf("sql was: %s<BR>\n", $sql); |
145 |
|
|
146 |
$rs = mysql_query($sql, $con); |
$rs = mysql_tryquery($sql); |
147 |
|
|
148 |
// Initialize counter |
// Initialize counter |
149 |
$rowcount = 0; |
$rowcount = 0; |
150 |
|
|
151 |
// Cycle through the result set |
// Cycle through the result set |
152 |
while ( $row = mysql_fetch_array ( $rs ) ) { |
while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
153 |
$resource_id = Trim($row["resource_id"]); |
$resource_id = Trim($row["resource_id"]); |
154 |
$title = Trim($row["title"]); |
$title = Trim($row["title"]); |
155 |
|
|