전체 포인트 말고 월별 포인트로 하고 싶습니다. 채택완료

<?php
$nowdate = date("Y-m",time()); // 이번달
//$nowdate = date("Y-m-d",time()); // 이번일
$sYear = substr($nowdate, 0, 4)."년";
$sMonth = substr($nowdate,5,2)."월";
//$sDay = substr($nowdate,8,2)."일";</p><p>$sql = "SELECT * , COUNT(B.mb_id ) AS count, SUM( B.po_point ) AS point
FROM  $g4[member_table] as A
LEFT JOIN $g4[point_table] as B ON ( A.mb_id = B.mb_id AND A.mb_level < 11 AND A.mb_point >= 1) where date_format(B.po_datetime,'%Y-%m') = '$nowdate' group by B.mb_id order by point desc LIMIT 0, 100 ";
$result = sql_query($sql);
?>

<?php
// 전체회원수
$mbcnt_all_po = sql_fetch("select count(mb_id) as cnt from `$g4[member_table]`");</p><p>$sql_common = " and mb_id != '' ";
if ($mb['mb_id']) {
    $sql = " select count(mb_id) as cnt from {$g4[member_table]} where mb_point > '{$view_point}' {$sql_common} order by mb_point desc ";
    $row = sql_fetch($sql);
    $percent_cnt_po = intval(1 *$row['cnt']) / intval(1 * $mbcnt_all_po['cnt']) * 100;
    $percent_po_ct = round($percent_cnt_po, 0); // 반올림
    $percent_po = $percent_po_ct;
}</p><p>
</p><p>echo $percent_po;
?>