point 랭킹 게시판인데요..

 이게.. 정렬이..... 그 머냐.. 포인트 순서로 정렬을 하고 있거든요?

 문제는..

 그렇게 안하고..

 최근에 가입한 날짜를 기준으로... 정렬을 할 수 없나 해서 질문 드립니다..



 다음은 소스 입니다..


 질문 요약 : 게시판 정렬 순서를 포인트가 아닌 최근 가입일을 기준으로 하고 싶습니다..

 어디를 어떻게 고쳐야 할지 질문 드립니다..

<?
include_once("./_common.php");
include_once("$g4[path]/lib/latest.lib.php");

if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

include_once("$g4[path]/head.sub.php");
include_once("$g4[path]/lib/outlogin.lib.php");
include_once("$g4[path]/lib/poll.lib.php");
include_once("$g4[path]/lib/visit.lib.php");
include_once("$g4[path]/lib/connect.lib.php");
include_once("$g4[path]/lib/popular.lib.php");

//print_r2(get_defined_constants());

// 사용자 화면 상단과 좌측을 담당하는 페이지입니다.
// 상단, 좌측 화면을 꾸미려면 이 파일을 수정합니다.





$token = get_token();

$sql_common = " from $g4[member_table] ";

$sql_search = " where (1) ";
if ($stx) {
    $sql_search .= " and ( ";
    switch ($sfl) {
        case "mb_point" :
            $sql_search .= " ($sfl >= '$stx') ";
            break;
        case "mb_level" :
            $sql_search .= " ($sfl = '$stx') ";
            break;
        case "mb_tel" :
        case "mb_hp" :
            $sql_search .= " ($sfl like '%$stx') ";
            break;
        default :
            $sql_search .= " ($sfl like '$stx%') ";
            break;
    }
    $sql_search .= " ) ";
}

//if ($is_admin == 'group') $sql_search .= " and mb_level = '$member[mb_level]' ";
if ($is_admin != 'super')
    $sql_search .= " and mb_level <= '$member[mb_level]' ";

if (!$sst) {
    $sst = "mb_datetime";
    $sod = "desc";
}

$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
        $sql_common
        $sql_search
        $sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

// 탈퇴회원수
$sql = " select count(*) as cnt
        $sql_common
        $sql_search
            and mb_leave_date <> ''
        $sql_order ";
$row = sql_fetch($sql);
$leave_count = $row[cnt];

// 차단회원수
$sql = " select count(*) as cnt
        $sql_common
        $sql_search
            and mb_intercept_date <> ''
        $sql_order ";
$row = sql_fetch($sql);
$intercept_count = $row[cnt];


$g4[title] = "회원관리";

$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
$result = sql_query($sql);

$colspan = 15;
?>
<script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>
<style type="text/css">
<!--
.bk123 {
border: 1px solid #CCCCCC;
}
.bkbk {
border: 1px solid #999999;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<table width="725" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="../images/bar0901.jpg" width="725" height="40"></td>
  </tr>
</table>
<br>
<table width="725" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="right" valign="middle"><table width="90" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="20"><img src="<?=$board_skin_path?>/img/icon_total.gif" width="14" height="14" border='0' align="absmiddle"></td>
          <td width="70" align=center><span class="style1">Total</span>
            <?=number_format($total_count)?></td>
        </tr>
      </table></td>
  </tr>
</table>
<table width="725" border="0" cellpadding="0" cellspacing="0" >
  <tr>
    <td height="100" colspan="6" align="left" valign="middle"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="bk123">
        <?
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 "<br><a href=/bbs/board.php?bo_table=bd21&wr_id=1 target=mainFrame><b><font size=5 color=#FF2B2B>추천현황보기</font></b></a><br><br>레벨상황 : 현재 <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="150" height="25" align="center" valign="middle" background="img/title_bg.gif"><b><font color="#ffffff">랭킹</font></b></td>
    <td width="150" height="25" align="center" valign="middle" background="img/title_bg.gif"><b><font color="#ffffff">닉네임</font></b></td>
    <td width="150" height="25" align="center" valign="middle" background="img/title_bg.gif"><b><font color="#ffffff">아이디</font></b></td>
    <td width="150" height="25" align="center" valign="middle" background="img/title_bg.gif"><b><font color="#ffffff">추천인</font></b></td>
    <td width="170" height="25" align="center" valign="middle" background="img/title_bg.gif"><b><font color="#ffffff">가입날짜</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]'";
}
if($_GET[type]==3)
{
$keyword_yi="where mb_recommend='$_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="아이디";
}
if($_GET[type]==3)
{
$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_recommend]);
$id = $row[mb_recommend];
 

?>
  <tr height="30" >
    <td width="150" height="35" align="center" valign="middle" ><?=$rank?></td>
    <td width="150" height="35" align="center" valign="middle"><?= level_icon($row[mb_id])?>
      <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 width="150" height="35" align="center" valign="middle"><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="150" height="35" align="center" valign="middle"><font color=green>
      <?=$row[mb_recommend]?>
      </font>&nbsp;</td>
    <td width="170" height="35" align="center" valign="middle"><font color="#FF0000">
      <?=$row[mb_datetime]?></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="695" height="20" border="0" cellpadding="0" cellspacing="0">
        <form id="form1" name="form1" method="get" action="">
          <tr>
            <td width="455" 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="200" 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>
                  <option value="3" <?php if($_GET[type]==3){ echo "selected";}?>>추천인</option>
                </select>
                <input name="keyword" type="text" class="bkbk" id="keyword" size="15" value="<?=$_GET[keyword]?>"/>
              </div></td>
            <td width="40" align="right"><input type="image" name="imageField" src="img/btn_post_search.gif" /></td>
          </tr>
        </form>
      </table></td>
  </tr>
</table>
<br>