$sub_menu = "100900"; include_once("./_common.php"); auth_check($auth[$sub_menu], "r"); $sql_common = " from $g4[banner_table] "; $sql_search = " where 1=1"; if ($stx) { $sql_search .= " and ( "; switch ($sfl) { default : $sql_search .= " ($sfl like '$stx%') "; break; } $sql_search .= " ) "; } if (!$sst) { $sst = "bn_datetime"; $sod = "desc"; } $sql_order = " order by $sst $sod "; $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 count(*) as cnt $sql_common $sql_search and bn_openchk = '1' $sql_order "; $row = sql_fetch($sql); $start_count = $row[cnt]; // 미사용 $sql = " select count(*) as cnt $sql_common $sql_search and bn_openchk <> '1' $sql_order "; $row = sql_fetch($sql); $end_count = $row[cnt]; $listall = "처음"; $g4[title] = "배너관리"; include_once("./admin.head.php"); $sql = " select * $sql_common $sql_search $sql_order limit $from_record, $rows "; $result = sql_query($sql); $colspan = 15; ?>
| "; echo " "; echo ""; echo " | "; echo "$pagelist |