게시물 읽음 전체 합산
//게시물뷰
$sql_common = " from {$g5['board_new_table']} a, {$g5['board_table']} b, {$g5['group_table']} c where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = 1 ";
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id {$sql_common} ";
$result = sql_query($sql);
$t_view = 0;
while($row=sql_fetch_array($result)) {
$tmp_write_table = $g5['write_prefix'].$row['bo_table'];
$row2 = sql_fetch(" select sum(wr_hit) as total from {$tmp_write_table} where wr_id = '{$row['wr_id']}' ");
$t_view += $row2['total'];
}
echo number_format($t_view);
$sql_common = " from {$g5['board_new_table']} a, {$g5['board_table']} b, {$g5['group_table']} c where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = 1 ";
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id {$sql_common} ";
$result = sql_query($sql);
$t_view = 0;
while($row=sql_fetch_array($result)) {
$tmp_write_table = $g5['write_prefix'].$row['bo_table'];
$row2 = sql_fetch(" select sum(wr_hit) as total from {$tmp_write_table} where wr_id = '{$row['wr_id']}' ");
$t_view += $row2['total'];
}
echo number_format($t_view);
게시글 목록
| 번호 | 제목 |
|---|---|
| 23798 | |
| 23797 | |
| 23792 | |
| 23791 | |
| 23785 | |
| 23781 | |
| 23770 | |
| 23766 | |
| 23764 | |
| 23761 | |
| 23747 | |
| 23732 | |
| 23724 | |
| 23718 | |
| 23706 | |
| 23700 | |
| 23697 | |
| 23686 | |
| 23682 | |
| 23681 | |
| 23680 | |
| 23678 | |
| 23665 | |
| 23644 | |
| 23643 | |
| 23639 | |
| 23637 | |
| 23630 | |
| 23626 | |
| 23616 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기