포인트순으로 정렬을 어케하는지..


<?php
$sub_menu = "200810";
include_once("./_common.php");

auth_check($auth[$sub_menu], "r");

$token = get_token();

$g4[title] = "현재접속자";
include_once("./admin.head.php");

$select_login_count = "select count(1) as login_count
from g4_login";
$select_login_count_result = sql_fetch($select_login_count);
$select_login_count_result = $select_login_count_result[login_count];

$select_login_list = "select *
from g4_login
order by lo_datetime desc";
$select_login_list_result = sql_query($select_login_list);
$select_login_count = sql_fetch_array($select_login_list_result[login_count]);
?>
<table border="0" width="100%" align="center">
<tr>
<td><strong><font color="black">총접속자 : <?=$select_login_count_result?> 명</font></strong></td>
</tr>
<tr>
<td>
<table border="1" width="80%">
<tr>
<td width="15%" align="center"><strong>아이디</strong></td>
<td width="15%" align="center"><strong>닉네임</strong></td>
<td width="12%" align="center"><strong>포인트</strong></td>
<td width="20%" align="center"><strong>시간</strong></td>
<td width="30%" align="center"><strong>위치</strong></td>
</tr>
<?
for($i=0;$row=sql_fetch_array($select_login_list_result);$i++){
$mb_nick = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
$mb_info = get_member($row[mb_id]);
?>
<tr>
<td align="center"><strong><font color="black"><?=$row[mb_id]?></font></strong> </td>
<td align="center"><strong><font color="black"><?=$mb_nick?></font></strong> </td>
<td align="right"><font color="red"><?=number_format($mb_info[mb_point])?> <font color="black">원</font> </td>
<td align="center"><strong><font color="black"><?=$row[lo_datetime]?></font></strong> </td>
<td><?=$row[lo_location]?> </td>

</tr>
<?}?>
</table>
</td>
</tr>
</table>

<?
include_once ("./admin.tail.php");
?>