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

우악이 라고 합니다.

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

우선 복많이 받으시구요.

설명들어갑니다.

해당 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);

-생략-

}

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

검색만하는것이구요. 검색버튼 눌렸을때만 활성화가 되어 먹힙니다. 위에 쿼리 보시면 $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 = "<a href='?id=".$id.$pageLink."&con1=대기' >";
$con1NoLink = "<a href='?id=".$id.$pageLink."&con1=진행' >";
$con1OkLink = "<a href='?id=".$id.$pageLink."&con1=완료' >";

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($s_time) $searchQuery[] = " s_time like '%$s_time%' ";
if($s_company!='전체') $searchQuery[] = " s_company='$s_company' ";
if($s_local) $searchQuery[] = " s_local like '%$s_local%' ";
if($s_place) $searchQuery[] = " s_place like '%$s_place%' ";
if($s_tel) $searchQuery[] = " s_tel like '%$s_tel%' ";
if($s_num) $searchQuery[] = " s_num like '%$s_num%' ";
if($model3) $searchQuery[] = " model3 like '%$model3%' ";
if($e_as) $searchQuery[] = " e_as like '%$e_as%' ";
if($gubun3) $searchQuery[] = " gubun3 like '%$gubun3%' ";
if($e_time) $searchQuery[] = " e_time like '%$e_time%' ";
if($diff_time) $searchQuery[] = " diff_time like '%$diff_time%' ";
if($gubun4) $searchQuery[] = " gubun4 like '%$gubun4%' ";
if($e_name2) $searchQuery[] = " e_name2 like '%$e_name2%' ";
if($w_name2) $searchQuery[] = " w_name2 like '%$w_name2%' ";
// if($dis_h) $searchQuery[] = " dis_h like '%$dis_h%' ";
// if($dis_m) $searchQuery[] = " dis_m like '%$dis_m%' ";

// 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]);

$searchDate[] = " w_date<$e_date1 ";
}


if($w_date || $e_date)
{
$searchDate = join('and',$searchDate);

if($searchQuery)
{
$searchDate = " (".$searchDate.") ";
$searchQuery = $searchQuery." and ".$searchDate;

}
else
{
$searchQuery = $searchDate;
}
}

if($exec3==1)
{
$searchQuery .= " and (e_date>$w_date1 and e_date<$e_date1) ";
}
if($exec3==2)
{
$searchQuery .= " and (e_date>$e_date1 or e_date='') ";
}
}
else
{
$searchQuery = stripslashes($exec0);
}

if($searchQuery) $searchQuery = " where ".$searchQuery;
}

--------------------------------------------------------------

//쿼리 mysql

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

$listQuery = mysql_query($listSelect);

오늘날짜00:00 이후 모든 게시글만 추출하고싶은데 $searchQuery 에 조건도 되있어서 어떻게 만져야될지 방향이안잡힙니다.

 제가 하려는것은 오늘날짜 00시 이후 게시글만 리스트에 뿌릴려합니다.

하지만 $searchQuery 에 묶여있는 like문 검색쿼리들 때문에 변형을하여도 검색할때도 오늘날짜 이후꺼만 되서요.. $SearchQuery 이게 문제 인데 이걸 어떻게 해야될지 죽겠습니다 ㅜㅜ 도와주세요 형님들

조회버튼을 누를시 search_ok라는 구문을 타는거같습니다.

아참 그리고 w_date , e_date 값이  11자리 숫자로 되있습니다 ㅠ 1441033201 이런식요

도움좀 주십시요 ㅠㅠ