별점 주는 소스인데 순위별이 될가용?

· 2011-03-18 (금) 14:56:51 · 1956 · 1
아래 별점 주는 소스라고하더라구요 이것을 높은값을 위로 해서 순위별로 나열되게 할려고하는데 가능할가용?

<?
$cmtpoint ='0';
$totalcount = '0';
$userrating = '0';

$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
$result2 = sql_query($sql2);

while($row2 = mysql_fetch_array($result2) ) {
$point=$row2[0];
$cmtpoint=$cmtpoint + $point;
$totalcount++;
}

if ($totalcount!=0) {
$cmtpoint= $cmtpoint/$totalcount;
$cmtpoint= number_format($cmtpoint,2);
}
echo "<a href='{$list[$i][href]}'>";

?>
<font color="gray">
<? if ($cmtpoint > "9"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif">
<? } else if ($cmtpoint > "8"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif">
<? } else if ($cmtpoint > "7"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "6"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "5"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "4"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "3"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "2"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "1"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "0"){?>
<img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else {?>
<img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? }?>
|

댓글 1개

$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";

윗부분을 아래처럼

$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ORDER BY 점수필드 DESC";
댓글을 작성하시려면 로그인이 필요합니다.

그누4 질문답변

66,531건

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기 기존 게시물은 열람만 가능합니다.

+
제목 글쓴이 날짜 조회
11-03-18 조회 1,957
11-03-18 조회 1,708
11-03-18 조회 1,583
11-03-18 조회 1,604
11-03-18 조회 1,693
11-03-18 조회 1,851
11-03-18 조회 1,158
11-03-18 조회 1,560
11-03-18 조회 1,050
11-03-18 조회 1,649
11-03-18 조회 1,687
11-03-18 조회 1,964
11-03-18 조회 1,886
11-03-18 조회 2,136
11-03-18 조회 1,644
11-03-17 조회 1,801
11-03-17 조회 1,677
11-03-17 조회 2,378
11-03-17 조회 1,634
11-03-17 조회 1,618