특정게시판의 글갯수와 코멘트 갯수만을 메인화면에 표시하기 위해
본문
<?php
$row = sql_fetch(" select sum(bo_count_write) as total_count from g5_board");
echo $row[total_count];
?>
<?php
$row = sql_fetch(" select sum(bo_count_comment) as total_count from g5_board");
echo $row[total_count];
?>
위 모든게시판의 글수와 댓글수 구하기를 notice게시판만 구하기 위해 아래같이 했는데 어디가 틀린걸까요?
<?php
$row = sql_fetch(" select sum(bo_count_write) as total_count from g5_write_notice");
echo $row[total_count];
?>
<?php
$row = sql_fetch(" select sum(bo_count_comment) as total_count from g5_write_notice");
echo $row[total_count];
?>
!-->!-->
답변 3
모든 게시판
$res = sql_query(" select * from g5_board ");
$tot_count = 0;
$tot_comment = 0;
for($i=0;$row=sql_fetch_array($res);$i++){
$bo = sql_fetch(" select count(*) as cnt from g5_write_".$row['bo_table']." where wr_comment =0 "); //원글만
$co = sql_fetch(" select count(*) as cnt from g5_write_".$row['bo_table']." where wr_comment =1 "); //코멘트만
$tot_count += $bo['cnt']; //원글
$tot_comment += $co[['cnt']; //코멘트
}
notice 만
$row = sql_fetch(" select sum(*) as total_count from g5_write_notice where wr_comment =0 ");
echo $row['total_count'];
$row = sql_fetch(" select sum(*) as total_count from g5_write_notice where wr_comment =1");
echo $row['total_count'];
이렇게 해보세요
$row
['total_count'];
<?php
$row = sql_fetch("select bo_count_write from $g5[board_table] where bo_table = 'notice'");
echo $row[bo_count_write];
?>
이 코드는 되긴 하는데 어디 잘못 된곳 있을까요?
!-->