"; ################################################################################################ ########################################## 공지사항 ############################################ $n_sql = "select * from $board_table where db='$board_db' && notice= '1' $addboard order by no desc "; $n_res = mysql_query($n_sql); while($n_row = @mysql_fetch_array($n_res)){ ########################################## 코멘트 갯수 ############################################ $c_sql = "select count(num) from $comment_table where usernum = '$n_row[num]'"; $c_row = mysql_fetch_array(mysql_query($c_sql)); if($c_row[0]) $comment_cnt = " [$c_row[0]]"; else $comment_cnt = ""; ########################################## 코멘트 갯수 ############################################ $n_subject = b_string_cut($n_row[subject], 30, "..."); $n_subject = "$n_subject $comment_cnt"; if(date("Y-m-d") == substr($n_row[wdate], 0, 10)){ $n_date = "".substr($n_row[wdate], 0, 10).""; $newIco = "

"; } else { $n_date = substr($n_row[wdate], 0, 10); $newIco = ""; } echo"

$n_subject $newIco $n_row[name] $n_date $n_row[hit] "; } ########################################## 공지사항 ############################################ ################################################################################################ #################################### 게시물 리스트 S ########################################### $item = $page_skip; if(!$item) $item = 10; $pageitem = $pagenumber; if(!$pageitem) $pageitem = 10; if(!$page) $page = 1; $start = ($page - 1) * $item; $totalpage = ceil($total / $item); $pnum = $total - (($page-1) * $item); $sql = "select * from $board_table where db='$board_db' $addwhere order by idx desc, sort asc limit $start, $item"; //echo $sql; $res = mysql_query($sql); while($row = mysql_fetch_array($res)){ ########################################## 코멘트 갯수 ############################################ $c_sql = "select count(num) from $comment_table where usernum='$row[num]'"; $c_row = mysql_fetch_array(mysql_query($c_sql)); if($c_row[0]) $comment_cnt = " [$c_row[0]]"; else $comment_cnt = ""; ########################################## 코멘트 갯수 ############################################ if($row[open_view] == "no"){ if($login_id == $row[id] && $row[id]){ $close_icon = "

"; $write_name = $row[name]; $subject = "$row[subject]"; } else { $close_icon = "

"; $write_name = $row[name]; //$write_name = "******"; $subject = "$row[subject]"; } } else { $close_icon = ""; $write_name = $row[name]; $subject = $row[subject]; } $subject = b_string_cut($subject, $subject_length, "..."); $subject = "$subject"; if($row[sort]){ $subject = "

".$subject; for($i=0; $i"; $newIco = "

"; } else { $wdate = substr($row[wdate],0,10); $newIco = ""; } $file = explode("||", $row[exname]); $file_name = explode("||", $row[file_name]); if($file_name[0]) $ficon1 = "

"; else $ficon1 = ""; if($file_name[1]) $ficon2 = "

"; else $ficon2 = ""; if($file_name[2]) $ficon3 = "

"; else $ficon3 = ""; if($pnum%2) $bgcolor = "#FFFFFF"; else $bgcolor = "#FFFFFF"; $contents = ereg_replace("

", "", ereg_replace("

", "", html_entity_decode($row[contents]))); echo"

$subject $newIco $close_icon	조회 : $row[hit]

".b_string_cut($contents, 150, "...")."

"; } if(!$total){ echo" 등록(검색)된 글이 없습니다. "; } echo"

"; $fquery = "board_db=$board_db&column=$column&keyword=$keyword"; psk_pagelinkB($totalpage, $pageitem, $page, "$board_img/prev.gif", "$board_img/next.gif", $fquery); echo"

"; print_button("write_form", "i_write.gif"); echo"

"; #### 검색 폼 S #### if($action != "read"){ echo"

"; } #### 검색 폼 E #### ?>