= $board[bo_write_level]) {
$sql_common = " from $table_member ";
$sql_search = " where (1) ";
if ($stext) {
$sql_search .= " and ( ";
$sql_search .= " ($sselect like '%$stext%') ";
$sql_search .= " ) ";
}
if (!$ssort) {
$ssort = "wr_id";
$sorder = "desc";
}
$sql_order = " order by $ssort $sorder ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 11; //페이지
$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);
$colspan = 5; // 칸수
?>