--- trunk/admin/mastersubject_drill.phtml	2004/03/18 20:21:08	71
+++ trunk/admin/mastersubject_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);
 
@@ -42,7 +52,7 @@
 if(isset($libsession) && $sess_access_level >= 20) {
 
 	// Fetch the mastersubject descr. field
-	$mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
+	$mastersubject = lookupField("mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
 
 	printf("<center>\n");
 	printf("<h3>Master Subject '%s' (#%d) contains the following Subjects:</h3>", $mastersubject, $mastersubject_id);
@@ -74,13 +84,13 @@
 
 	// printf("sql was: %s<BR>\n", $sql);
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 
 	// Initialize counter
 	$rowcount = 0;
 
 	// Cycle through the result set
-	while ( $row = xx_fetch_array ( $rs ) ) {
+	while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$subject_id = Trim($row["subject_id"]);
 		$subject = Trim($row["subject"]);
 
@@ -133,13 +143,13 @@
 
 	// printf("sql was: %s<BR>\n", $sql);
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 
 	// Initialize counter
 	$rowcount = 0;
 
 	// Cycle through the result set
-	while ( $row = xx_fetch_array ( $rs ) ) {
+	while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$resource_id = Trim($row["resource_id"]);
 		$title = Trim($row["title"]);