88 |
// Initialize counter |
// Initialize counter |
89 |
$rowcount = 0; |
$rowcount = 0; |
90 |
|
|
91 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
92 |
|
|
93 |
// Cycle through the result set |
// Cycle through the result set |
94 |
while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ( $row = xx_fetch_array ($rs, xx_ASSOC)) { |
95 |
$subject = Trim($row["subject"]); |
$subject = Trim($row["subject"]); |
96 |
$subject_id = Trim($row["subject_id"]); |
$subject_id = Trim($row["subject_id"]); |
97 |
$title = Trim($row["title"]); |
$title = Trim($row["title"]); |
116 |
*****************************/ |
*****************************/ |
117 |
|
|
118 |
printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n"); |
printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n"); |
119 |
if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n"); |
if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n"); |
120 |
else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs)); |
else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs)); |
121 |
printf("</tr>\n"); |
printf("</tr>\n"); |
122 |
|
|
123 |
// Close table |
// Close table |
145 |
// Initialize counter |
// Initialize counter |
146 |
$rowcount = 0; |
$rowcount = 0; |
147 |
|
|
148 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
149 |
|
|
150 |
// Cycle through the result set |
// Cycle through the result set |
151 |
while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ( $row = xx_fetch_array ($rs, xx_ASSOC)) { |
152 |
$resource_id = Trim($row["resource_id"]); |
$resource_id = Trim($row["resource_id"]); |
153 |
$title = Trim($row["title"]); |
$title = Trim($row["title"]); |
154 |
|
|
168 |
|
|
169 |
// Summary of occurences in resources |
// Summary of occurences in resources |
170 |
printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n"); |
printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n"); |
171 |
if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n"); |
if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n"); |
172 |
else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs)); |
else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs)); |
173 |
printf("</tr>\n"); |
printf("</tr>\n"); |
174 |
|
|
175 |
// Close table |
// Close table |