주간 조회수 높은 순서대로 10개의 게시물 뽑기

<?php

if($bo_table == "free") {

// 코멘트

function wrc($cnt,$comment) {

if($comment == "0") {

$Rs = sql_fetch(" select count(wr_parent) as cnt from g5_write_free where wr_is_comment = '1' and wr_parent = '".$cnt."' group by wr_is_comment ");

$RR = $Rs['cnt'];

if($RR) {

return "<span style='color:#ff0000;font-weigh:bold;'>[".$RR."]</span>";

}

}

}

// 일주일 리스트 hit 순서대로 10 개만 가져오기

$sql = " select * from g5_write_free where wr_datetime > date_add(now(),interval -7 day) order by wr_hit desc limit 10 ";

$Query = sql_query($sql);

$i = "1";

while($Row = sql_fetch_array($Query)){

if($i <= '3') { $best = "best"; }else{ $best = ""; }

if($Row['wr_subject']) {

$weeklist[] = "<li class='".$best."'><span class='ranking'>".$i."</span><a href='http://ety.kr/board/free#038;amp;wr_id=".$Row['wr_id']."'><strong>[".$list[$i]['ca_name']."]</strong> ".cut_str($Row['wr_subject'],'25','..').wrc($Row['wr_parent'],$Row['wr_is_comment'])."</a></li>";

}

$i++;

}

?>

<div class='section_ol'>

<ol>

<?php echo $weeklist[0];?>

<?php echo $weeklist[1];?>

<?php echo $weeklist[2];?>

<?php echo $weeklist[3];?>

<?php echo $weeklist[4];?>

</ol>

</div>

<div class='section_ol'>

<ol>

<?php echo $weeklist[5];?>

<?php echo $weeklist[6];?>

<?php echo $weeklist[7];?>

<?php echo $weeklist[8];?>

<?php echo $weeklist[9];?>

</ol>

</div>

<?

  }

?>