<?
include_once("./_common.php");

$html_title = "R.a.n.k.";
$g4[title] = "" . $html_title;
include_once("./_head.php");

?>
<table style="width:540" align="center" cellpadding="3" cellspacing="0">
<tr><td valign=top colspan=2 class=lh>
<?
if ($member[mb_id]) {
    $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);
    echo "· 현재 회원님의 포인트는  <B>".number_format($member[mb_point])."점</B> 이며, 순위는 <B>".number_format($row[cnt] + 1)."등</B> 입니다.<br />";
}

$sql = " select sum(mb_point) as sum_point from $g4[member_table]";
$row = sql_fetch($sql);
$sum_point = $row[sum_point];
//echo "· 전체 포인트 : <b>".number_format($sum_point) . "점</b><br />";
echo "</td></tr>";
echo "<tr><td colspan=2><table width=100% align=center cellpadding=0 cellspacing=0>";
echo "<tr><td height=20 width=80 align=center bgcolor='#F2F2F2'>";
echo "<form style='margin:0px;'><font color='#505050'>Nick</font></td><td><input type=text name='stx2' id='stx2' value='$stx2' class='ed'> <input type=submit value='검색'>  <input type=button onclick=\"location.href='/point_rank.php'\" value='전체'></form>";
echo "</td></tr>";
echo "</table><br /></td></tr>";
echo "<tr><td valign=top width=50%>";

$where = " (1) ";
if ($stx2)
    $where = " mb_nick like '%$stx2%' ";

$sql = " select count(*) as cnt from $g4[member_table] where $where ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = 50;
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
if ($page > 5) $page = 1;
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$mod = 25;

$sql = " select * from $g4[member_table]
          where $where
          order by mb_point desc, mb_today_login desc
          limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
    if ($i && $i%$mod==0)
        echo "</td><td valign=top>";

    if ($stx2)
    {
        $sqlx = " select count(mb_id) as cnt from $g4[member_table] where mb_point > '$row[mb_point]' order by mb_point desc ";
        $rowx = sql_fetch($sqlx);
        $rank = $rowx['cnt'] + 1;
    }
    else
        $rank = number_format((($page - 1) * $rows) + $i + 1);

 $name = "<span style=\"cursor:help;\" title=\"( {$row[mb_id]} )\">{$row[mb_nick]}</span>";

    $mb_point = $row['mb_point'];
    $point = number_format($mb_point);
    $p = "{$point}점";

    echo "<table width=100% cellpadding=0><tr style=\"background-color:#ededed;\">";
    echo "<td style=\"width:30;height:20;text-align:center;font-weight:bold;color:#555\">$rank</td>";
    echo "<td style=\"width:100;height:20;text-align:center;font-weight:bold;color:#555\">$name</td>";
    echo "<td> </td>";
    echo "<td style=\"width:80;height:20;text-align:center;font-weight:bold;color:#555\">$p</td>";
    echo "</tr></table>";
}
?>
</td></tr>
</table>

<?
$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&stx2=$stx2&page=");
include_once("./_tail.php");
?>

이런식으로 포인트 순위를 뽑아주고 있는데요..
탈퇴된 멤버가 그대로 보여지더라구요.. 탈퇴회원을 리스트에서 제외하거나 따로 탈퇴된회원이라고 표시하고 싶은데 도와주세요 !