--- branches/paul/admin/rqscip_crosswalk.phtml	2004/03/07 19:15:27	66
+++ branches/paul/admin/rqscip_crosswalk.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);
 
@@ -70,21 +80,18 @@
 	$rowcount = 0;
         $sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code
         	FROM subject s
-        	LEFT JOIN sub_coursesub sc using (subject_id)
+        	LEFT JOIN sub_coursesub sc on s.subject_id = sc.subject_id
         	LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id
         	WHERE s.subject_id > 1
-        	ORDER BY subject";
+        	ORDER BY s.subject";
 
-	// printf("sql was: %s<BR>", $sql);
+	$rs = mysql_tryquery($sql);
 
-	$rs = mysql_query($sql, $con);
-	
-	while ($row = mysql_fetch_array ($rs)) {
+	while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
 
 		// Increment counter
 		$rowcount++;
 		
-		
 		// Make every other third row colored
 		if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
 		else $color = "";		
@@ -110,7 +117,7 @@
 
 		printf("<tr>\n");
 		
-		if ($subject_id != $last_subject_id ) printf("<td>%s</td>\n", $subject_link);
+		if ($subject_id != $last_subject_id) printf("<td>%s</td>\n", $subject_link);
 		else printf("<td>&nbsp;</td>\n");
 		
 		if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code);
@@ -124,7 +131,7 @@
 
         };
         
-        printf("<tr><td colspan=\"2\" class=\"cellPlain\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount);
+        printf("<tr><td colspan=\"2\" class=\"backLight\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount);
         printf("</table>");
         
 	// Link to return to admin console