function display_occupation() { if (func_num_args()) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; $validuser = $arg_list[3]; $isadmin = $arg_list[4]; } print "<table width='400'>"; print "<tr valign='top'><td colspan='3'>"; print "<span class='library'>" . FTITLE_OCCUPATION_LIST . "</span><br>"; print "</td></tr>"; print "<tr valign='top'><td><b>" . THEAD_ID . "</b></td><td><b>" . THEAD_NAME . "</b></td></tr>"; $sql = "select o.occup_cat, o.occup_id, o.occup_name " . "from m_lib_occupation o, m_lib_occupation_cat c " . "where o.occup_cat = c.cat_id order by c.cat_name, o.occup_name"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { while (list($cat, $id, $name) = mysql_fetch_array($result)) { if ($prev_cat != $cat) { print "<tr valign='top' bgcolor='#FFCC00'><td colspan='2'><b>" . strtoupper(occupation::get_occupcat_name($cat)) . "</b></td></tr>"; } print "<tr valign='top'><td>{$id}</td><td><a href='" . $_SERVER["SELF"] . "?page=" . $get_vars["page"] . "&menu_id={$menu_id}&occup_id={$id}#form_occupation'>{$name}</a></td></tr>"; $prev_cat = $cat; } } } print "</table><br>"; }