setSubMainInit($cate); //$row = $board->execSubMainList($cate); $where = " WHERE LEFT(a.cate,2)='".$cate."' AND is_view=1 AND a.is_del=0"; if($keyfield!=="" && $keyword!="") { $where .= " AND a.".$keyfield." like '".$keyword."%' "; } $sql = "SELECT COUNT(a.seq) FROM ".$board->table_name ." a INNER JOIN ACR_BOARD_CONFIG b on a.cate=b.cate INNER JOIN ACR_ITEM_CODE c on a.item_code=c.item_code and c.is_del=0 $where"; $record_num = $db->oquery($sql); //$pagecount = ceil(($record_num-1)/PAGESCALE)+1; $startnum=($record_num-(($curpage-1)*SCALE2))+1; $start = ($curpage-1)*SCALE2; $param = "code=".$code."&cate=".$cate; ?>
Home > Life > 전체기사
table_name ." a INNER JOIN ACR_BOARD_CONFIG b on a.cate=b.cate INNER JOIN ACR_ITEM_CODE c on a.item_code=c.item_code $where ORDER BY a.reg_date DESC limit ".$start.",".SCALE2; //$sql = "SELECT a.seq,a.unic_code,a.cate,a.item_code,a.small_code,a.subject,a.writer,a.writer_name,a.message,a.write_date,a.write_hour,a.write_min,a.thum_dir,a.thum_name,b.header,c.item_name FROM ".$board->table_name ." a INNER JOIN ACR_BOARD_CONFIG b on a.cate=b.cate INNER JOIN ACR_ITEM_CODE c on a.item_code=c.item_code and c.is_del=0 $where ORDER BY a.write_date DESC,a.write_hour DESC,a.write_min DESC limit ".$start.",".SCALE2; $sql = "SELECT a.seq,a.unic_code,a.cate,a.issue_code,a.small_code,a.subject,a.writer,a.writer_name,a.message,a.write_date,a.write_hour,a.write_min,a.thum_dir,a.thum_name,b.header,c.code_name FROM ".$board->table_name ." a INNER JOIN ACR_BOARD_CONFIG b on a.cate=b.cate INNER JOIN ACR_ISSUE_CODE c on a.issue_code=c.code and c.is_del=0 $where ORDER BY a.write_date DESC,a.write_hour DESC,a.write_min DESC limit ".$start.", 10"; $db->query($sql); $num_row = $db->get_num_rows(); if($num_row>0) { while($row = $db->next_record()) { if($row['thum_name']) { $thum_dir = IMG_SERVER."/".$row['thum_dir']."/".$row['thum_name']; }else{ $thum_dir = IMG_SERVER."/updata/logo/acrofan_logo_200150.jpg"; } ?>
&ucode=&page=&keyfield=&keyword=">
&ucode=&page=&keyfield=&keyword=">
&ucode=&page=&keyfield=&keyword=">cut_str($row['message'],300,"..."))?>
 
 
 
page_nav($record_num,SCALE2,SCALE3,$curpage,$param)?>