".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' and ".$prefix."category='$categ' order by ".$prefix."msg_date desc, ".$prefix."msg_id limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 4"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // order값이 desc일때, 즉 목록순서로 정렬할 때이다. ********************************** if($order == "desc") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** //$result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth, ".$prefix."filename, ".$prefix."msg_body"from $tablename order by ".$prefix."msg_date desc, ".$prefix."author asc, ".$prefix."msg_subject asc limit $start_page, $max_msg_per_page"); $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth, ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_date desc, ".$prefix."author asc, ".$prefix."msg_subject asc limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 3"; exit; } $num_rows = mysql_num_rows($result); } // order값이 asc일때, 즉 시간순서로 정렬할 때이다. ********************************** else if ($order == "asc") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_date desc, ".$prefix."msg_id limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 4"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } // order값이 hit일때, 즉 조회순서로 정렬할 때이다. ********************************** else if ($order == "hit") { //**************************************************************************** $result = mysql_query("select count(*) from $tablename where ".$prefix."yesno='$yesdisp' "); if(!$result) { print "DB Error No.1[contact to webmaster]"; exit; } $query_data = mysql_fetch_row($result); $msg_total = $query_data[0]; $count_message = "총 ".$msg_total." 개의 게시물이 있습니다."; // BLUEICE Debugging 1999. 8. 21 [generate page_total] if(($msg_total % $max_msg_per_page) == 0){ $page_total = (int) ($msg_total / $max_msg_per_page); // No remain } else{ $page_total = (int) ($msg_total / $max_msg_per_page) + 1; } $result = mysql_query("select count(*) from $tablename where ".$prefix."thread_info='000'"); if(!$result) { print "DB Error No.2"; exit; } $query_data = mysql_fetch_row($result); $thread_total = $query_data[0]; //**************************************************************************** $result = mysql_query("select ".$prefix."msg_id, ".$prefix."thread_id, ".$prefix."msg_subject, ".$prefix."author, ".$prefix."msg_hit, ".$prefix."msg_date, ".$prefix."thread_depth , ".$prefix."file1name, ".$prefix."msg_body, ".$prefix."file2name, ".$prefix."file3name,".$prefix."category from $tablename where ".$prefix."yesno='$yesdisp' order by ".$prefix."msg_hit desc, ".$prefix."msg_id desc limit $start_page, $max_msg_per_page"); if(!$result) { print "Error occurred. No 5"; mysql_close(); exit; } $num_rows = mysql_num_rows($result); } ?> cellspacing=0 cellpadding=0>

cellspacing=0 cellpadding=0> >         [분류] 생활 문화 정치 경제 사회 정보통신 기타 > >목록순 > >시간순 > >조회순 "; else $attach1 = " "; if($file2name != "") $attach2 = ""; else $attach2 = " "; if($file3name != "") $attach3 = ""; else $attach3 = " "; if($catsort == '1'){ $catlet='생활'; } else if($catsort == '2'){ $catlet='문화'; } else if($catsort == '3'){ $catlet='정치'; } else if($catsort == '4'){ $catlet='경제'; } else if($catsort == '5'){ $catlet='사회'; } else if($catsort == '6'){ $catlet='정보통신'; } else { $catlet='기타'; } $datetime = split(" ", $msg_date); $msg_date = $datetime[0]; $msg_time = $datetime[1]; ?>   width=600 height=20 > " ?>   color=black>   color=black>''     color=black>     270) { echo text_cut($content,267)."..."; } else { echo $content."..."; } ?>     " ?> >   <<Before "; for($s=$startdiv; $s<=$enddiv; $s++){ if($page_total < $s){ break; } if($s == $cur_page) echo "".$s." " ; else echo "".$s." " ; } if($enddiv < $page_total) echo " Next>>"; ?>