', 0); add_stylesheet('', 0); if($_GET['sca']){ $_GET['sca'] = get_text($_GET['sca']); $options1 = "and (`ca_name`='{$_GET['sca']}') "; if($_GET['wr_10']){ $wr10 = get_text($_GET['wr_10']); $sub = get_text($_GET['wr_subject']); $options1 = "and (`ca_name`='{$_GET['sca']}' && `wr_10`='{$wr10}') "; } } if($_GET['wr_subject']){ $sub = $_GET['wr_subject']; $options2 = "and (`wr_subject` like '%{$sub}%') "; } if($_GET['wr_4']){ $wr4 = substr($_GET['wr_4'],0,6); $options3 = " and (`wr_4` like '%{$wr4}%') "; } $page = $_GET['page']; if(!$page){ $page = "1"; } $cnt = sql_fetch("SELECT count(*) as 'cnt' FROM `g5_write_{$board['bo_table']}` WHERE `wr_comment`='0' {$options1} {$options2} {$options3};"); $total_count = $cnt['cnt']; $rows = 10; $total_page = ceil($total_count / $rows); // 전체 페이지 계산 $from_record = ($page - 1) * $rows; // 시작 열을 구함 $query = sql_query("SELECT * FROM `g5_write_{$board['bo_table']}` WHERE `wr_comment`='0' {$options1} {$options2} {$options3} ORDER BY `wr_id` DESC LIMIT {$from_record},{$rows};"); $list = array(); for($i=0; $rows = sql_fetch_array($query); $i++){ $list[$i] = $rows; $list[$i]['subject'] = $list[$i]['wr_subject']; $list[$i]['href'] = G5_BBS_URL."/board.php?bo_table={$board['bo_table']}&wr_id=".$list[$i]['wr_id']; } ?>