--- trunk/admin/res_drill.phtml	2004/03/18 20:21:08	71
+++ trunk/admin/res_drill.phtml	2004/03/18 20:33:37	72
@@ -17,6 +17,16 @@
 printf("</HEAD>\n");
 
 
+// Default access settings
+$sess_time_human = "";
+$sess_staff_account = "";
+$sess_staff_id = 0;
+$sess_access_level = 0;
+$sess_access = "";
+$sess_last_name = "";
+$sess_first_name = "";
+
+
 // Page header
 require_once ($GLOBAL_ADMIN_HEADER);
 
@@ -48,13 +58,13 @@
 	$resource_id = (int) $resource_id;
 
 	// Check to see if resource exists
-	$exists = existsRow($con, "resource", "resource_id", $resource_id);
+	$exists = existsRow("resource", "resource_id", $resource_id);
 
 	// If resource exists
 	if ($exists > 0) {
 
 		// Fetch the resource title
-		$title = lookupField($con, "resource", "resource_id", $resource_id, "title");
+		$title = lookupField("resource", "resource_id", $resource_id, "title");
 
 		printf("<center>\n");
 		printf("<h3>Resource Title '%s' (#%d) used on the following:</h3>", $title, $resource_id);
@@ -90,10 +100,10 @@
 		// Initialize counter
 		$rowcount = 0;
 
-		$rs = xx_query($sql, $con);
+		$rs = xx_tryquery($sql);
 
 		// Cycle through the result set
-		while ( $row = xx_fetch_array ( $rs ) ) {
+		while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 			$subject = Trim($row["subject"]);
 			$subject_id = Trim($row["subject_id"]);			
 			$infotype = Trim($row["infotype"]);
@@ -144,10 +154,10 @@
 		// Initialize counter
 		$rowcount = 0;
 
-		$rs = xx_query($sql, $con);
+		$rs = xx_tryquery($sql);
 
 		// Cycle through the result set
-		while ( $row = xx_fetch_array ( $rs ) ) {
+		while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 			$page_id = Trim($row["page_id"]);
 			$course_concat = Trim($row["course_concat"]);
@@ -195,10 +205,10 @@
 		// Initialize counter
 		$rowcount = 0;
 
-		$rs = xx_query($sql, $con);
+		$rs = xx_tryquery($sql);
 
 		// Cycle through the result set
-		while ( $row = xx_fetch_array ( $rs ) ) {
+		while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 			$page_id = Trim($row["page_id"]);
 			$page_title = Trim($row["page_title"]);