포인트랭킹에서 레벨10은 제외하려고합니다 채택완료

</strong></p>

<p>

    <?php

    //$sql = " select SUM(IF(a.po_point>0,a.po_point,0)) AS sumpoint, b.mb_point, b.mb_nicname from {$g5['point_table']} a, {$g5['member_table']} b where a.mb_id=b.mb_id group by a.mb_id order by sumpoint desc limit 0, 50 ";

    //$sql = " select SUM(IF(po_point>0,po_point,0)) AS sumpoint, mb_id from {$g5['point_table']} where mb_id != 'qadmin' group by mb_id order by sumpoint desc  limit 0, 50";

    $sql = " SELECT SUM(IF(a.po_point>0,a.po_point,0)) AS sumpoint, b.mb_id, b.mb_point, b.mb_nick FROM {$g5['point_table']} a, {$g5['member_table']} b WHERE a.mb_id=b.mb_id AND b.mb_id != 'qadmin' GROUP BY a.mb_id ORDER BY mb_point DESC limit 0, 50";

    $result = sql_query($sql);</p>

<p>    for ($i=0; $row=sql_fetch_array($result); $i++) {

        //$sql2 = " select * from {$g5['member_table']} where mb_id= '{$row['mb_id']}' ";

        //$row2 = sql_fetch($sql2);

    ?>

            <tr>

                  <td class="rank"><?=$i+1?>위</td>

                  <td class="left"><?=level_icon($row['mb_id'])?> <?=$row['mb_nick']?></td>

                  <td><?=number_format($row['sumpoint'])?>점</td></p>

<p><strong>