7일간 전체게시물 코멘트가 많은 순서대로 10개만 출력하기 정보
7일간 전체게시물 코멘트가 많은 순서대로 10개만 출력하기본문
<?php
// 전체 게시판 테이블 출력
$Select_Board = " select * from g4_board ";
$Select_Board_Cnts = sql_fetch(" select count(bo_table) Cnts from g4_board ");
$Query_Board = sql_query($Select_Board);
$Select_Write = ""; // 변수 초기화
for($i=1; $Row_Board = sql_fetch_array($Query_Board); $i++){
$Select_Write .= "(
select wr_datetime, wr_parent, count(wr_parent) as wr_count , '".$Row_Board['bo_table']."' as bo_table FROM `".$g4['write_prefix'].$Row_Board['bo_table']."`
where wr_comment != 0
and wr_is_comment = 1
and date(wr_datetime) >= date(subdate(now(), INTERVAL 7 DAY))
group by wr_parent
)";
if($i != $Select_Board_Cnts['Cnts']){
$Select_Write .= " UNION ";
}
}
$Select_Write .= " order by wr_count desc limit 10 ";
$Query_Write = sql_query($Select_Write);
while($Row_Write = sql_fetch_array($Query_Write)){
$Row_Info = sql_fetch(" select wr_subject, wr_comment from ".$g4['write_prefix'].$Row_Write['bo_table']." where wr_id = ".$Row_Write['wr_parent']." ");
echo $Row_Info['wr_subject'].' - '.$Row_Info['wr_comment'];
echo '<br/>';
}
?>
디자인은 각자 알아서 하세요..^^;;
// 전체 게시판 테이블 출력
$Select_Board = " select * from g4_board ";
$Select_Board_Cnts = sql_fetch(" select count(bo_table) Cnts from g4_board ");
$Query_Board = sql_query($Select_Board);
$Select_Write = ""; // 변수 초기화
for($i=1; $Row_Board = sql_fetch_array($Query_Board); $i++){
$Select_Write .= "(
select wr_datetime, wr_parent, count(wr_parent) as wr_count , '".$Row_Board['bo_table']."' as bo_table FROM `".$g4['write_prefix'].$Row_Board['bo_table']."`
where wr_comment != 0
and wr_is_comment = 1
and date(wr_datetime) >= date(subdate(now(), INTERVAL 7 DAY))
group by wr_parent
)";
if($i != $Select_Board_Cnts['Cnts']){
$Select_Write .= " UNION ";
}
}
$Select_Write .= " order by wr_count desc limit 10 ";
$Query_Write = sql_query($Select_Write);
while($Row_Write = sql_fetch_array($Query_Write)){
$Row_Info = sql_fetch(" select wr_subject, wr_comment from ".$g4['write_prefix'].$Row_Write['bo_table']." where wr_id = ".$Row_Write['wr_parent']." ");
echo $Row_Info['wr_subject'].' - '.$Row_Info['wr_comment'];
echo '<br/>';
}
?>
디자인은 각자 알아서 하세요..^^;;
추천
10
10
댓글 1개
좋아요 10정도 올라가면 디자인부터 완벽하게 올려드리겠습니다.
g4 g5 dtd 버전별로 표준화 해서 올려드리겠습니다.
g4 g5 dtd 버전별로 표준화 해서 올려드리겠습니다.