78 |
// Initialize counter |
// Initialize counter |
79 |
$rowcount = 0; |
$rowcount = 0; |
80 |
|
|
81 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
82 |
|
|
83 |
// Cycle through the result set |
// Cycle through the result set |
84 |
while ( $row = mysql_fetch_array ( $rs ) ) { |
while ( $row = xx_fetch_array ( $rs ) ) { |
85 |
$subject = Trim($row["subject"]); |
$subject = Trim($row["subject"]); |
86 |
$subject_id = Trim($row["subject_id"]); |
$subject_id = Trim($row["subject_id"]); |
87 |
$title = Trim($row["title"]); |
$title = Trim($row["title"]); |
106 |
*****************************/ |
*****************************/ |
107 |
|
|
108 |
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"); |
109 |
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"); |
110 |
else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs)); |
else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs)); |
111 |
printf("</tr>\n"); |
printf("</tr>\n"); |
112 |
|
|
113 |
// Close table |
// Close table |
135 |
// Initialize counter |
// Initialize counter |
136 |
$rowcount = 0; |
$rowcount = 0; |
137 |
|
|
138 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
139 |
|
|
140 |
// Cycle through the result set |
// Cycle through the result set |
141 |
while ( $row = mysql_fetch_array ( $rs ) ) { |
while ( $row = xx_fetch_array ( $rs ) ) { |
142 |
$resource_id = Trim($row["resource_id"]); |
$resource_id = Trim($row["resource_id"]); |
143 |
$title = Trim($row["title"]); |
$title = Trim($row["title"]); |
144 |
|
|
158 |
|
|
159 |
// Summary of occurences in resources |
// Summary of occurences in resources |
160 |
printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n"); |
printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n"); |
161 |
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"); |
162 |
else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs)); |
else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs)); |
163 |
printf("</tr>\n"); |
printf("</tr>\n"); |
164 |
|
|
165 |
// Close table |
// Close table |