php

if($wr_1) {
	$qstr.= "&wr_1=$wr_1";
	$sql_search .= " and wr_1 ='$wr_1' ";
	$extend_search[] = " (INSTR(wr_1, '$wr_1')) ";
}

if($wr_2) {
	$qstr.= "&wr_2=$wr_2";
	$sql_search .= " and wr_2 ='$wr_2' ";
	$extend_search[] = " (INSTR(wr_2, '$wr_2')) ";
}

if($wr_3) {
	$qstr.= "&wr_3=$wr_3";
	$sql_search .= " and wr_3 ='$wr_3' ";
	$extend_search[] = " (INSTR(wr_3, '$wr_3')) ";
}


for($z=0;$z<count($extend_search);$z++) {
	if($z==0) {
		if($sca || $stx || $stx == '0') {
			$extend .= " and ".$extend_search[$z];
		} else {
			$extend .= " and ".$extend_search[$z];
		}
	} else {
		$extend .= " and ".$extend_search[$z];
	}
}

$sql = " SELECT COUNT(DISTINCT 'wr_parent') AS 'cnt' FROM {$write_table} WHERE {$sql_search} {$extend} "; 

if($is_search_bbs) {
	$sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$extend} {$sql_order} limit {$from_record}, $page_rows ";
} else {
	$sql = " select * from {$write_table} where wr_is_comment = 0  {$extend} ";
	if(!empty($notice_array)) {
		$sql .= " and wr_id not in (".implode(', ', $notice_array).") ";
		$sql .= " {$sql_order} limit {$from_record}, $page_rows ";
	}
}