--- branches/paul/admin/infotype_drill.phtml	2004/03/07 19:15:27	66
+++ branches/paul/admin/infotype_drill.phtml	2004/03/18 19:24:54	67
@@ -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);
 
@@ -43,7 +53,7 @@
 
 
 	// Fetch the information type descr. field
-	$infotype = lookupField($con, "infotype", "infotype_id", $infotype_id, "infotype");
+	$infotype = lookupField("infotype", "infotype_id", $infotype_id, "infotype");
 
 	printf("<center>\n");
 	printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);
@@ -78,10 +88,10 @@
 	// Initialize counter
 	$rowcount = 0;
 
-	$rs = mysql_query($sql, $con);
+	$rs = mysql_tryquery($sql);
 
 	// Cycle through the result set
-	while ( $row = mysql_fetch_array ( $rs ) ) {
+	while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
 		$subject = Trim($row["subject"]);
 		$subject_id = Trim($row["subject_id"]);			
 		$title = Trim($row["title"]);
@@ -135,10 +145,10 @@
 	// Initialize counter
 	$rowcount = 0;
 
-	$rs = mysql_query($sql, $con);
+	$rs = mysql_tryquery($sql);
 
 	// Cycle through the result set
-	while ( $row = mysql_fetch_array ( $rs ) ) {
+	while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
 		$resource_id = Trim($row["resource_id"]);			
 		$title = Trim($row["title"]);