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 |
|
|
66 |
mastersubject |
mastersubject |
67 |
FROM mastersubject |
FROM mastersubject |
68 |
ORDER BY mastersubject"; |
ORDER BY mastersubject"; |
69 |
|
$rs = xx_tryquery($sql); |
|
$rs = xx_query($sql, $con); |
|
70 |
|
|
71 |
// Initialize counter |
// Initialize counter |
72 |
$rowcount = 0; |
$rowcount = 0; |
73 |
|
|
74 |
// Cycle through the result set |
// Cycle through the result set |
75 |
while ( $row = xx_fetch_array ( $rs ) ) { |
while ( $row = xx_fetch_array ($rs, xx_ASSOC)) { |
76 |
$mastersubject_id = Trim($row["mastersubject_id"]); |
$mastersubject_id = Trim($row["mastersubject_id"]); |
77 |
$mastersubject = Trim($row["mastersubject"]); |
$mastersubject = Trim($row["mastersubject"]); |
78 |
|
|
98 |
. $mastersubject_id |
. $mastersubject_id |
99 |
. " ORDER BY m.masterinfotype, i.infotype"; |
. " ORDER BY m.masterinfotype, i.infotype"; |
100 |
|
|
101 |
$sub_rs = xx_query($sub_sql, $con); |
$sub_rs = xx_tryquery($sub_sql); |
102 |
$sub_rowcount = 0; |
$sub_rowcount = 0; |
103 |
|
|
104 |
// Cycle through the result set |
// Cycle through the result set |
105 |
while ( $sub_row = xx_fetch_array ( $sub_rs ) ) { |
while ( $sub_row = xx_fetch_array ($sub_rs, xx_ASSOC)) { |
106 |
$masterinfotype = Trim($sub_row["masterinfotype"]); |
$masterinfotype = Trim($sub_row["masterinfotype"]); |
107 |
$infotype = Trim($sub_row["infotype"]); |
$infotype = Trim($sub_row["infotype"]); |
108 |
|
|