모든게시판의 글리스트 만들기 채택완료

참고만 해 보세요.

$query=sql_query("select bo_table,bo_subject from g5_board");

while($rows=sql_fetch_array($query)) {  $res[]="(select *, '". $rows['bo_table'] ."' as bo_table from g5_write_". $rows['bo_table'] ." where wr_is_comment=0)"; 

$tmp="select count(*) as cnt from g5_write_". $rows['bo_table'] ." where wr_is_comment=0"; $row=sql_fetch($tmp); $total_count +=(int)$row['cnt']; }

$rows=$config['cf_page_rows']; $total_page=ceil($total_count/$rows);   if($page<1) { $page=1; }  $from_record=($page-1)*$rows; 

echo "전체글 ". $total_count ."개";

$res=implode("union all", $res); $res .=" order by wr_datetime desc limit {$from_record}, {$rows}"; $query=sql_query($res);

for($i=0; $row=sql_fetch_array($query); $i++) { $bo_subject=sql_fetch("select * from g5_board where bo_table='{$row['bo_table']}'");

$row['wr_datetime']=substr($row['wr_datetime'],0,10); echo '

['. $rowt['bo_subject'].']'. $row['wr_subject'] .'-'.$row['wr_datetime'].'

echo get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['PHP_SELF'].'?'.$qstr.'&page=');  ?>