<%
// DB Connect
include "../inc/dbconnect.inc";
include "../inc/counterview.inc";
$h_page = getenv("SERVER_NAME");
$board = "qna";
$Table_Name = "Free_Board";
$Admin_Page = "../admin/admin_menu.html"; //관리자 페이지
$C_Page = "qna_list.html"; //현제 페이지
$V_Page = "qna_view.html"; //보기 페이지
$S_Page = "qna_search.html"; //검색 페이지
$W_Page = "qna_write.html"; //쓰기 페이지
$pageSize = 10; // 페이지당 리스트 개수
$block_page = 10; // 페이지이동 개수
if ($curPage == ""){
$curPage=1;
}
$list_NO = $pageSize * ($curPage-1);
//$SQLString = "SELECT COUNT(no) AS total FROM $Table_Name";
//$SQLString = $SQLString . " Where board = '$board'";
//$Rs = mysql_query($SQLString,$DBConn);
//$SQLString = "";
//$total_record = mysql_result($Rs,0,"total"); //총 등록된수
//mysql_free_result($Rs);
//if ($total_record <= 0) $total_record = 0; // 총게시물의 값이 없거나 할경우 기본값으로 세팅
//$total_page = floor(($total_record - 1) / $pageSize) + 1; // 총 페이지 수
$condi_url = "";
if ($search == "Yes") {
// 검색 조건
$condi_url = "&search=$search&writer=$writer&subject=$subject&comment=$comment&s_word=$s_word";
$S_Result = "SELECT no,subno,depno,writer,regdate,subject,email,visit FROM $Table_Name WHERE board = '$board' AND " ;
$S_Count = "SELECT COUNT(no) AS total_cnt FROM $Table_Name WHERE board = '$board' AND " ;
if( $writer == "ON" ) {
$S_Result = $S_Result . " writer Like '%$s_word%' ";
$S_Count = $S_Count . " writer Like '%$s_word%' ";
}
if( $subject == "ON" ) {
if( $writer == "ON" ) {
$S_Result = $S_Result . "OR ";
$S_Count = $S_Count . "OR ";
}
$S_Result = $S_Result . "subject Like '%$s_word%' ";
$S_Count = $S_Count . "subject Like '%$s_word%' ";
}
if ( $comment == "ON" ) {
if( $writer == "ON" || $subject == "ON" ) {
$S_Result = $S_Result . "OR ";
$S_Count = $S_Count . "OR ";
}
$S_Result = $S_Result . "comment Like '%$s_word%' ";
$S_Count = $S_Count . "comment Like '%$s_word%' ";
}
$S_Result = $S_Result . " ORDER By no DESC";
} else {
$S_Result = "Select no,subno,depno,writer,regdate,subject,email,visit From $Table_Name Where board = '$board' ORDER By no DESC";
$S_Count = "Select Count(no) AS total_cnt From $Table_Name Where board = '$board'";
}
$Rs = mysql_query($S_Count,$DBConn);
$S_Count = "";
$total_record = mysql_result($Rs,0,"total_cnt");
mysql_free_result($Rs);
if ($total_record <= 0) $total_record = 0; // 총게시물의 값이 없거나 할경우 기본값으로 세팅
$total_page = floor(($total_record - 1) / $pageSize) + 1; // 총 페이지 수
$S_Result = $S_Result . " Limit $list_NO,$pageSize";
$Rs = mysql_query($S_Result,$DBConn);
$S_Result = "";
$postcount = mysql_num_rows($Rs);
%>
::::: 서울검사주식회사 :::::
<%
mysql_free_result($Rs);
include "../inc/dbclose.inc";
%>
