그룹 게시물 갯수

모든 그룹

<?php

$result = sql_query("select a.gr_id, sum( bo_count_write ) count, gr_subject from g5_board a left join g5_group b on a.gr_id = b.gr_id group by a.gr_id");

while($row = sql_fetch_array($result)) {

echo $row[gr_id].'
'; // 그룹ID

echo $row[gr_subject].'
'; // 그룹명

echo $row[count].'
'; // 그룹게시글수

}

?>

특정 그룹

<?php

$row = sql_fetch("select a.gr_id, sum( bo_count_write ) count, gr_subject  from g5_board a left join g5_group b on a.gr_id = b.gr_id where a.gr_id = '그룹ID' group by a.gr_id");

echo $row[gr_id].'
'; // 그룹ID

echo $row[gr_subject].'
'; // 그룹명

echo $row[count].'
'; // 그룹게시글수

?>

특정그룹 제외한 게시물

select a.gr_id, sum( bo_count_write ) count, gr_subject from g5_board a left join g5_group b on a.gr_id = b.gr_id group by a.gr_id and a.gr_id <> 'community';