--- branches/paul/admin/info_structure.phtml 2004/03/07 19:15:27 66 +++ branches/paul/admin/info_structure.phtml 2004/03/18 19:24:54 67 @@ -17,6 +17,16 @@ printf("\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); @@ -56,14 +66,13 @@ mastersubject FROM mastersubject ORDER BY mastersubject"; - - $rs = mysql_query($sql, $con); + $rs = mysql_tryquery($sql); // Initialize counter $rowcount = 0; // Cycle through the result set - while ( $row = mysql_fetch_array ( $rs ) ) { + while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { $mastersubject_id = Trim($row["mastersubject_id"]); $mastersubject = Trim($row["mastersubject"]); @@ -89,11 +98,11 @@ . $mastersubject_id . " ORDER BY m.masterinfotype, i.infotype"; - $sub_rs = mysql_query($sub_sql, $con); + $sub_rs = mysql_tryquery($sub_sql); $sub_rowcount = 0; // Cycle through the result set - while ( $sub_row = mysql_fetch_array ( $sub_rs ) ) { + while ( $sub_row = mysql_fetch_array ($sub_rs, MYSQL_ASSOC)) { $masterinfotype = Trim($sub_row["masterinfotype"]); $infotype = Trim($sub_row["infotype"]);