--- branches/paul/public_controls.php	2004/03/18 19:58:18	68
+++ branches/paul_xx/public_controls.php	2004/03/18 20:01:09	69
@@ -49,8 +49,8 @@
 		WHERE
 		page_id = " . $page_id;
 	
-	$rs = mysql_tryquery($sql);
-	$row = mysql_fetch_array ($rs, MYSQL_ASSOC);
+	$rs = xx_tryquery($sql);
+	$row = xx_fetch_array ($rs, xx_ASSOC);
 
 	$course_id = $row["course_id"];	
 	$staff_id_created = $row["staff_id_created"];
@@ -149,10 +149,10 @@
 		WHERE
 		course_id = " . $course_id . " ORDER BY personnel_id";
 	
-	$rs = mysql_tryquery($sql);
+	$rs = xx_tryquery($sql);
 	
 	// See how many in this record set
-	$num_personnel = mysql_num_rows($rs);
+	$num_personnel = xx_num_rows($rs);
 
 	if ($num_personnel > 0) {
 
@@ -161,7 +161,7 @@
 		printf("<b>Personnel:</b><br>\n");
 
 
-		while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+		while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 			// Initialize
 			$last_name = "";
@@ -240,8 +240,8 @@
         		. $subject_id
     			. " AND sp.page_id = p.page_id ORDER BY p.page_title";
         
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$page_id = $row["page_id"];
 		$page_title = $row["page_title"];
 
@@ -276,8 +276,8 @@
         	. $subject_id
         	. " AND so.othersub_id = s.subject_id ORDER BY s.subject";
         	
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$othersub_id = $row["othersub_id"];
 		$subject = $row["subject"];	
 
@@ -308,8 +308,8 @@
 	// Calculate number of elements
 	$sql = "SELECT COUNT(*) as num_elements FROM element WHERE indent_level < 1 AND page_id = "
 		. $page_id;
-	$rs = mysql_tryquery($sql);
-	$row = mysql_fetch_array ($rs);
+	$rs = xx_tryquery($sql);
+	$row = xx_fetch_array ($rs);
 	$num_elements = $row["num_elements"];
 
 	// Calculate midpoint element	
@@ -348,7 +348,7 @@
 			. $page_id
 			. " AND e.indent_level < 1 ORDER BY e.element_order";
 
-		$rs = mysql_tryquery($sql);
+		$rs = xx_tryquery($sql);
 
 		// Build a general ToC anchor
 		printf("<a name=\"toc\"></a>\n");
@@ -363,7 +363,7 @@
 		
 		$row_num = 0;
 		
-		while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+		while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 		
 			// Check for the midpoint
 			if ($row_num  == $midpoint && $wrap_toc == 1) {
@@ -461,8 +461,8 @@
         	AND s.coursesub_id = c.coursesub_id "
         	. " ORDER BY s.coursesub";
 
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$coursesub = $row["coursesub"];
 		
                 printf("<option value = \"%s\"", $coursesub);
@@ -505,8 +505,8 @@
         	AND p.published = '1'"
         	. " ORDER BY f.faculty_lastname, f.faculty_firstname";
         
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 		$faculty_id = $row["faculty_id"];
 		$faculty_lastname = $row["faculty_lastname"];
 		$faculty_firstname = $row["faculty_firstname"];
@@ -559,8 +559,8 @@
 		. $where
                 . " ORDER BY "
                 . $field_display;
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
                 $field_display_item = $row[$field_display];
 		if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "...";                
                 $field_value_item = $row[$field_value];
@@ -609,8 +609,8 @@
                 . " ORDER BY "
                 . $field_display;
         
-        $rs = mysql_tryquery($sql);
-        while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
+        $rs = xx_tryquery($sql);
+        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
                 $field_display_item = $row[$field_display];
                 $field_value_item = $row[$field_value];
 		if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "...";
@@ -654,8 +654,8 @@
 		. "="
 		. $limit_id;
 
-        $rs = mysql_tryquery($sql);
-        $rowcount = mysql_num_rows($rs);
+        $rs = xx_tryquery($sql);
+        $rowcount = xx_num_rows($rs);
 	if ($rowcount >= 1){
 		$rowcount = 1;
 	}
@@ -696,9 +696,9 @@
 		. "='"
 		. $key_value
 		. "'";
-        $rs = mysql_tryquery($sql);
-        $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
-        if (mysql_num_rows($rs) == 1) $result = $row[$desc_field];
+        $rs = xx_tryquery($sql);
+        $row = xx_fetch_array ($rs, xx_ASSOC);
+        if (xx_num_rows($rs) == 1) $result = $row[$desc_field];
 	else $result = "";
 	
 	return $result;
@@ -723,8 +723,8 @@
 
         $sql = "SELECT first_name, last_name FROM staff WHERE staff_id = "
         	. $staff_id;
-        $rs = mysql_tryquery($sql);
-        $row = mysql_fetch_array ($rs, MYSQL_ASSOC);
+        $rs = xx_tryquery($sql);
+        $row = xx_fetch_array ($rs, xx_ASSOC);
 	$last_name = $row["last_name"];
 	$first_name = $row["first_name"];
 	
@@ -767,7 +767,7 @@
 			. ", now(), '"
 			. $user_ip
 			. "')";
-	mysql_tryquery($sql);
+	xx_tryquery($sql);
 
 }
 
@@ -827,7 +827,7 @@
 			. ", now(), '"
 			. $user_ip
 			. "')";
-	mysql_tryquery($sql);
+	xx_tryquery($sql);
 
 }