7일간 포인트 순위
[code]
<?php
$Select = " select sum(po_point) as sum_point, mb_id from g5_point where po_datetime > DATE_ADD(now(),INTERVAl -7 day) group by mb_id order by sum_point desc ";
$Query = sql_query($Select);
while($Row = sql_fetch_array($Query)){
echo $Row['sum_point'].'<br/>';
//print_r($Row['mb_id']);
}
?>
[/code]
<?php
$Select = " select sum(po_point) as sum_point, mb_id from g5_point where po_datetime > DATE_ADD(now(),INTERVAl -7 day) group by mb_id order by sum_point desc ";
$Query = sql_query($Select);
while($Row = sql_fetch_array($Query)){
echo $Row['sum_point'].'<br/>';
//print_r($Row['mb_id']);
}
?>
[/code]
게시글 목록
| 번호 | 제목 |
|---|---|
| 32970 | |
| 32959 | |
| 32937 | |
| 32917 | |
| 32909 | |
| 32899 | |
| 32885 | |
| 32884 | |
| 32862 | |
| 32861 | |
| 32860 | |
| 32840 | |
| 32814 | |
| 32804 | |
| 32795 | |
| 32784 | |
| 32783 | |
| 32750 | |
| 32740 | |
| 32732 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기