아래 소스 참고 하세요
---------------------이하 소스 -------------------------------------------------------
<?
///////////////////// 수정하세요. //////////////////////////
$user_name="디비아이디"; // 자신의 계정 아이디를 적으시면 됩니다.
$db_name="디비네임"; // 자신의 MySQL DB 아이디를 적으세요.
$db_password="디비비번"; // 자신의 DB의 패스워드 입니다.
//////////////////////////////////////////////////////////
$conn = mysql_connect(localhost,$user_name,$db_password) or message(mysql_error());
mysql_select_db($db_name,$conn ) or mysql_error();
// 그룹정보 구하기
$group_info = mysql_query("select no,name from zetyx_group_table");
$group_num = mysql_num_rows($group_info);
while($group_data = mysql_fetch_array($group_info)){
$group_no = $group_data[no];
$group_name[] = $group_data[name];
$group_member_num[] = mysql_num_rows(mysql_query("select no from zetyx_member_table where group_no='$group_no'"));
$bbs_info = mysql_query("select name from zetyx_admin_table where group_no='$group_no'");
$group_bbs_num[] = mysql_num_rows($bbs_info);
$group_write_num = 0;
$group_comment_num = 0;
while($bbs_data = mysql_fetch_array($bbs_info)){
$board_name = $bbs_data[name];
$group_write_num += mysql_num_rows(mysql_query("select no from zetyx_board_$board_name"));
$group_comment_num += mysql_num_rows(mysql_query("select no from zetyx_board_comment_$board_name"));
}
$group_write_num_[] = $group_write_num;
$group_comment_num_[] = $group_comment_num;
}
// 계정전체 글/코멘트 수 구하기
$total_member = mysql_num_rows(mysql_query("select no from zetyx_member_table"));
$bbs_info = mysql_query("select name from zetyx_admin_table");
$bbs_num = mysql_num_rows($bbs_info);
while($bbs_data = mysql_fetch_array($bbs_info)){
$board_name = $bbs_data[name];
$write_num += mysql_num_rows(mysql_query("select no from zetyx_board_$board_name"));
$comment_num += mysql_num_rows(mysql_query("select no from zetyx_board_comment_$board_name"));
}
///// ********************* 출력하기 ********************* /////
// 그룹별
for($k=0; $k<$group_num; $k++){
echo ("<font size=2 color=blue><b>그룹[${group_name[$k]}]</b></font><br>");
총 게시물 수 : $group_write_num_[$k] 개<br>
총 코멘트 수 : $group_comment_num_[$k] 개</font><br>");
}
mysql_close($conn);
?>