회원 권한별, 랭킹을 뽑아내고 싶습니다.

"레벨상황: 현재 <b>".$member[mb_id]."</b>님의 포인트는 <B>".$member[mb_point]."점</B>";   $sql = " select count(mb_id) as cnt from $g4[member_table]              where mb_point >= '$member[mb_point]' order by mb_point desc ";    $row = sql_fetch($sql);   	 $sql2 = " select count(mb_id) as cnt from $g4[member_table]";    $row2 = sql_fetch($sql2);	 $total_count = $row2[cnt];    echo "&nbsp;이고,&nbsp;랭킹은 전체회원수 <b>".$total_count."</b>명중 <B>".number_format($row[cnt])."등</B> 입니다.<br>";

else if ($level = $row[mb_level] == 3)$level="A Class";

<?if (!defined("_GNUBOARD_")) exit;include_once("./_common.php");include_once("$g4[path]/head.sub.php");define("_CO_POINT_RANK_", TRUE);$html_title = "포인트 랭킹";$g4[title] = "" . $html_title;?><?if ($member[mb_level] < 1)echo "<script>alert('회원만 조회하실수 있습니다.');location.href='/bbs/login.php?wr_id=&url=point_rank.php';</script>";?><style type="text/css"><!--.bk123 {	border: 1px solid #CCCCCC;}.bkbk {	border: 1px solid #999999;}--></style> <table width="100%" border="0" cellpadding="0" cellspacing="0" >  <tr> <td height="15" colspan="6" align="left" valign="top"></td></tr>  <tr>    <td height="100" colspan="6" align="left" valign="middle"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="bk123">        <tr>          <td height="35" style="padding-left:20px;">회원권한제도: <img src="/level_img/level5.gif"> A Class, <img src="/level_img/level6.gif"> P Class, <img src="/level_img/level7.gif"> C Class, <img src="/level_img/level8.gif"> V Class, <img src="/level_img/level9.gif"> Staff, <img src="/level_img/level10.gif"> Master. </td>        </tr>		<?		if ($member[mb_id]) {?>        <tr>          <td height="35" style="padding-left:20px;"><?$sql = " select sum(mb_point) as sum_point from $g4[member_table]";$row = sql_fetch($sql);$sum_point = $row[sum_point];echo "레벨상황: 현재 <b>".$member[mb_id]."</b>님의 포인트는 <B>".$member[mb_point]."점</B>";   $sql = " select count(mb_id) as cnt from $g4[member_table]              where mb_point >= '$member[mb_point]' order by mb_point desc ";    $row = sql_fetch($sql);   	 $sql2 = " select count(mb_id) as cnt from $g4[member_table]";    $row2 = sql_fetch($sql2);	 $total_count = $row2[cnt];    echo "&nbsp;이고,&nbsp;랭킹은 전체회원수 <b>".$total_count."</b>명중 <B>".number_format($row[cnt])."등</B> 입니다.<br>";?></td>        </tr>		<? } ?>    </table></td>  </tr><tr ><td width="10%"><b><font color="blue">랭킹</font></b></td><td width="12%" background="img/title_bg.gif" height="25"><b><font color="blue">닉네임</font></b></td><td width="18%" background="img/title_bg.gif" height="25"><b><font color="blue">레벨 & 경험치</font></b></td><td width="20%" background="img/title_bg.gif" height="25"><b><font color="blue">아이디</font></b></td><td width="20%" background="img/title_bg.gif" align="right" height="25"><b><font color="blue">회원권한</font></b></td><td width="20%" align="right" background="img/title_bg.gif" ><b><font color="blue">포인트</font></b></td></tr> <tr> <td colspan="6" height="5"></td></tr> <tr> <td colspan="6" height="1" bgcolor="#CCCCCC"></td></tr> <tr> <td colspan="6" height="5"></td></tr> <?$sql = " select count(*) as cnt from $g4[member_table]";$row = sql_fetch($sql);$total_count = $row[cnt]; $rows = 20;$total_page  = ceil($total_count / $rows); if ($page == "") { $page = 1; }$from_record = ($page - 1) * $rows;  $mod = 48;$tbl_col =2 ; $tbl_col_sep = (int)($mod / $tbl_col) + ($mod % $tbl_col)  ;if($_GET[keyword]!=""){if($_GET[type]==0){$keyword_yi="where mb_nick='$_GET[keyword]'";}if($_GET[type]==1){$keyword_yi="where mb_name='$_GET[keyword]'";}if($_GET[type]==2){$keyword_yi="where mb_id='$_GET[keyword]'";}}$sql = " select * from $g4[member_table] $keyword_yi           order by mb_point desc, mb_today_login desc           limit $from_record, $rows ";		  $sql11 = " select count(*) from $g4[member_table] $keyword_yi           order by mb_point desc, mb_today_login desc           ";$result = sql_query($sql);$result11 = sql_query($sql11);//echo $rsn11;$rsn11=mysql_fetch_array($result11);if($rsn11[0]==0){if($_GET[type]==0){$ty="닉네임";}if($_GET[type]==1){$ty="이름";}if($_GET[type]==2){$ty="아이디";}  echo "<tr><td colspan=6 align=center height=150> 검색하신 $ty(<font color=red>$_GET[keyword]</font>) 에 대한 검색결과가 없습니다</td></tr>";}for ($i=0; $row=sql_fetch_array($result); $i++) {     $rank = (($page - 1) * $rows) + $i + 1;    $point = number_format($row[mb_point]);	$id = $row[mb_id];    ?>  <tr height="30" ><td width="13%" height="35" ><?=$rank?></td><td height="35"> <a title="쪽지보내기" onfocus='this.blur()' style="FILTER: blendTrans(duration=0.7); CURSOR: pointer" onclick="window.open('/bbs/memo_form.php?me_recv_mb_id=<?=$row[mb_id]?>','www_yiwuauction_com1','width=602,height=521,toolbars=no,resizable=no,scrollbars=no')"><?=$row[mb_nick]?></a>&nbsp;&nbsp;</td><td height="35"><?=exp_bar($row[mb_id],$row[mb_point],1);?></td><td width="20%" height="35"><a title="정보보기" onfocus='this.blur()' style="FILTER: blendTrans(duration=0.7); CURSOR: pointer" onclick="window.open('/bbs/profile.php?mb_id=<?=$row[mb_id]?>','www_yiwuauction_com2','width=602,height=521,toolbars=no,resizable=no,scrollbars=no')"><b><?=$row[mb_id]?></b></a></td><td width="24%" height="35" align="right"><? if ($level = $row[mb_level] == 10)$level="Master";else if ($level = $row[mb_level] == 7)$level="Staff";else if ($level = $row[mb_level] == 6)$level="V Class";else if ($level = $row[mb_level] == 5)$level="C Class";else if ($level = $row[mb_level] == 4)$level="P Class";else if ($level = $row[mb_level] == 3)$level="A Class";else if ($level = $row[mb_level] == 2)$level="New A Class";else if ($level = $row[mb_level] == 0)$level="비회원";?><font color=green><?=$level?></font>&nbsp;</td><td width="20%" height="35" align="right"><font color="#FF0000"><?=$point?>&nbsp;점</font></td></tr>  <tr><td colspan="6" height="1" background="img/dot_line.gif"></td></tr> <?	} ?>  <tr> <td colspan="6" height="30"></td></tr> <tr> <td height="20" colspan="6">   <table width="651" height="20" border="0" cellpadding="0" cellspacing="0">     <form id="form1" name="form1" method="get" action=""><tr>       <td width="423" valign="middle">	   	   <?	   if($_GET[keyword]=="")	   {$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");echo "<p><table width=100% cellpadding=0 cellspacing=0><tr><td align=center>$page</td></tr></table>";}?></td>       <td width="187" align="right" valign="middle">             <div align="center">         <select name="type" id="type">           <option value="0" <?php if($_GET[type]==0){ echo "selected";}?>>닉네임</option>           <option value="1" <?php if($_GET[type]==1){ echo "selected";}?>>이름</option>           <option value="2" <?php if($_GET[type]==2){ echo "selected";}?>>아이디</option>         </select>          <input name="keyword" type="text" class="bkbk" id="keyword" size="15" value="<?=$_GET[keyword]?>"/>       </div>          </td>       <td width="41" align="right"><input type="image" name="imageField" src="img/btn_post_search.gif" /></td>     </tr></form>   </table></td></tr> <tr>   <td height="15" colspan="6">&nbsp;</td> </tr></table>