--- branches/paul/admin/page_results_brief.phtml 2004/03/07 19:15:27 66 +++ branches/paul/admin/page_results_brief.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); @@ -254,12 +264,7 @@ $sql .= " ORDER BY " . $orderby . " " . $orderdir; } - // Debugging - // printf("sql was: %s
", $sql); - - if ( !$rs = mysql_query ( $sql, $con ) ) { - sql_err ( $sql ) And bailout(); - } + $rs = mysql_tryquery ($sql); // Table printf("
"); @@ -297,7 +302,7 @@ $rowcount = 0; // Cycle through the result set - while ( $row = mysql_fetch_array ( $rs ) ) { + while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { $page_id = $row["page_id"]; $page_title = Trim($row["page_title"]); $date_created = substr($row["date_created"], 0, 10);