$sub_menu = "300200"; include_once("./_common.php"); auth_check($auth[$sub_menu], "r"); $sql_common = " from $g4[group_table] "; $sql_search = " where (1) "; if ($is_admin == 'group') $sql_search .= " and (gr_admin = '$member[mb_id]') "; if ($stx) { $sql_search .= " and ( "; switch ($sfl) { case "gr_id" : case "gr_admin" : $sql_search .= " ($sfl = '$stx') "; break; default : $sql_search .= " ($sfl like '%$stx%') "; break; } $sql_search .= " ) "; } if ($sst) $sql_order = " order by $sst $sod "; else $sql_order = " order by gr_id asc "; $sql = " select count(*) as cnt $sql_common $sql_search $sql_order "; $row = sql_fetch($sql); $total_count = $row[cnt]; $rows = $config[cf_page_rows]; $total_page = ceil($total_count / $rows); // Àüü ÆäÀÌÁö °è»ê if (!$page) $page = 1; // ÆäÀÌÁö°¡ ¾øÀ¸¸é ù ÆäÀÌÁö (1 ÆäÀÌÁö) $from_record = ($page - 1) * $rows; // ½ÃÀÛ ¿À» ±¸ÇÔ $sql = " select * $sql_common $sql_search $sql_order limit $from_record, $rows "; $result = sql_query($sql); $listall = "óÀ½"; $g4[title] = "°Ô½ÃÆÇ±×·ì¼³Á¤"; include_once("./admin.head.php"); $colspan = 9; ?>
| "; echo ""; //echo " "; echo " | "; echo " | $pagelist |