글쓴이 : Yemam (211.♡.235.69)

조회 : 3,232  

// 총 인원 수
$sql = " select count(*) as cnt from $g4[member_table] where mb_today_login like '$g4[time_ymd]%' and mb_id != '$config[cf_admin]' order by mb_today_login";
$cnt = sql_fetch($sql);


$total_count = $cnt[cnt];
$rows = 14;
$total_page  = ceil($total_count / $rows);
if ($page == "") { $page = 1; }
$from_record = ($page - 1) * $rows;

총인원수를 구한다음

$sql = " select mb_id, mb_name, mb_nick, mb_level, mb_email, mb_homepage, mb_today_login, mb_point from $g4[member_table] where SUBSTRING(mb_today_login,1,10) = '$g4[time_ymd]' and mb_level < '10' order by mb_today_login DESC
limit $from_record, $rows";

요렇게 한 다음에

마지막에

$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
[이 게시물은 morning님에 의해 2012-02-26 10:55:04 그누소스에서 이동 됨]