형님들에게 여쭤봅니다. 좀 복잡스럽네요..

우선 안녕하십니까. 형님들.

우악이 라고 합니다.

게시판 리스트 문의좀 드려보고싶어서 글남깁니다.

우선 복많이 받으시구요.

설명들어갑니다.

해당 url 치고 들어가면 1.php 파일을 타는데 이안에 소스가 들어있습니다.

여기서 지금 문제가 리스트는 정상적으로 나오는데.

//쿼리 mysql

$listSelect = "select * from list_100 $searchQuery order by w_date desc , s_time desc limit $startNum, $endNum";

$listQuery = mysql_query($listSelect);

//값뿌림

while($listDate = mysql_fetch_array($listQuery)) { unset($e_date);

}unset($w_date,$w_name)$gnum--;}

여기서 $searchQuery 라는것은 위에 따로 정의된 변수입니다.

오로지 검색만하는것이구요.

~~~~~~~~~~~~~~~~~~$searchQuery 구문입니다.

if(!$exec || $exec == "list") { // 검색 if($exec2 == 'search_ok') { if(!$exec0) { if($groupOption1) if(!$groupO) $groupO = '전체'; if(!$model1) $model1 = '전체'; if(!$gubun1) $gubun1 = '전체'; if(!$gubun2) $gubun2 = '전체'; if(!$con1) $con1 = '전체'; if(!$s_company) $s_company = '전체';

// 링크 정의 if($exec2) $pageLink .= "&exec2=".$exec2; if($groupOption1) if($groupO!='전체') $pageLink .= "&groupO=".$groupO; if($model1!='전체') $pageLink .= "&model1=".$model1; if($model2) $pageLink .= "&model2=".$model2; if($s_time) $pageLink .= "&s_time=".$s_time; if($s_company!='전체') $pageLink .= "&s_company=".$s_company; if($s_local) $pageLink .= "&s_local=".$s_local; if($s_place) $pageLink .= "&s_place=".$s_place; if($s_tel) $pageLink .= "&s_tel=".$s_tel; if($s_num) $pageLink .= "&s_num=".$s_num; if($model3) $pageLink .= "&model3=".$model3; if($e_as) $pageLink .= "&e_as=".$e_as; if($gubun3) $pageLink .= "&gubun3=".$gubun3; if($e_time) $pageLink .= "&e_time=".$e_time; if($diff_time) $pageLink .= "&diff_time=".$diff_time; if($gubun4) $pageLink .= "&gubun4=".$gubun4; if($e_name2) $pageLink .= "&e_name2=".$e_name2; if($w_name2) $pageLink .= "&w_name2=".$w_name2;

if($dis_h) $pageLink .= "&dis_h=".$dis_h; if($dis_m) $pageLink .= "&dis_m=".$dis_m; if($gr) $pageLink .= "&gr=".$gr; if($gubun1!='전체') $pageLink .= "&gubun1=".$gubun1; if($gubun2!='전체') $pageLink .= "&gubun2=".$gubun2; if($w_date) $pageLink .= "&w_date=".$w_date; if($e_date) $pageLink .= "&e_date=".$e_date; if($keyword) $pageLink .= "&keyword=".$keyword; if($listRow) $pageLink .= "&listRow=".$listRow;

$con1YesLink = ""; $con1NoLink = ""; $con1OkLink = "";

if($con1!='전체') $pageLink .= "&con1=".$con1;

if($groupOption1) if($groupO!='전체') $searchQuery[] = " groupO='$groupO' ";

if($con1!='전체') $searchQuery[] = " con1='$con1' ";

/* 필요없는컬럼값 if($model1!='전체') $searchQuery[] = " model1='$model1' "; if($model2) $searchQuery[] = " model2 like '%$model2%' ";*/

// if($gr) $searchQuery[] = " dis_h like '$gr' ";

if($gubun1!='전체') $searchQuery[] = " gubun1='$gubun1' "; if($gubun2!='전체') $searchQuery[] = " gubun2='$gubun2' ";

if($groupOption1) $groupOQuery = " groupO like '%$keyword%' or ";

if($keyword) { $searchQuery[] = " ( $groupOQuery model1 like '%$keyword%' or model2 like '%$keyword%' or gubun1 like '%$keyword%' or gubun2 like '%$keyword%' or con1 like '%$keyword%' or w_name like '%$keyword%' or e_name like '%$keyword%' or w_memo like '%$keyword%' or e_memo like '%$keyword%' or s_place like '%$keyword%' or gubun4 like '%$keyword%' or s_tel like '%$keyword%') "; }

$searchQuery = @join('and',$searchQuery); if($searchQuery) $searchQuery = " (".$searchQuery.") ";

if($w_date) { $w_date1 = explode("-",$w_date); $w_date1 = mktime(0,0,0,$w_date1[1],$w_date1[2],$w_date1[0]);

$searchDate[] = " w_date>$w_date1 "; } if($e_date) { $e_date1 = explode("-",$e_date); $e_date1 = mktime(23,12,59,$e_date1[1],$e_date1[2],$e_date1[0]);