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]
|
댓글을 작성하시려면 로그인이 필요합니다.