= '$now_date' and gong='Y' order by updexpiry desc, no desc limit $pre_gaesu[pre]"; $mamul_sel = mysqli_query($connect,$mamul_sel); /**************************************************************************************/ /*********************************************************************************************/ // $mamul_Lsel = "select * from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y' order by updexpiry desc, no desc limit $start_q1, $scale1"; $mamul_Lsel = "select * from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y' order by wdate desc, no desc limit $start_q1, $scale1"; $mamul_Lsel = mysqli_query($connect,$mamul_Lsel); $mamul_LAll = "select count(no) from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y'"; $mamul_LAll = mysqli_query($connect,$mamul_LAll); $mamul_LAll = mysqli_fetch_array($mamul_LAll); /*********************************************************************************************/ /*********************************************************************************************************/ if($hahaha == 'sangsearch') { //&area1=$area1&area2=$area2&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk $cc=explode("-",$_GET['area1']); $ee=explode("-",$_GET['area2']); $ar1=($cc[2])?"and address2 like '%$cc[2]%'":""; $ar1.=($ee[2])?"and address2 like '%$ee[2]%'":""; if(!$area2_haha) { $area2_haha = $area2; } $area1_1 = explode("-",$area1); $area2_1 = explode("-",$area2_haha); $area2_1 = " $area2_1[2]"; $addresseses1 = $area1_1[2]; $addresseses2 = $area2_1; $jongru_1 = explode("-",$jongru); //$sangsearch1 = ($area1[2])?"and address2 like '%$addresseses1%' or address2 like '%$addresseses2%'":""; $sangsearch1 .= ($jongru[2])?"and gubun1='$jongru_1[2]'":""; $sangsearch1 .= ($jongru2)?"and gubun2='$jongru2'":""; $sangsearch1 .= ($searchkkk)?"and id like '%$searchkkk%'":""; if($searchjongru=="") {}else{ $sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="Y")?"and jointype='Y' ":"and jointype='N' "; $sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="N")?"and jointype='N' ":"and jointype='N' "; } $mamul_Lsel = "select * from $mamulcode where gong='Y' $ar1 $sangsearch1 order by updexpiry desc, no desc limit $start_q1, $scale1"; //echo $mamul_Lsel; $mamul_Lsel = mysqli_query($connect,$mamul_Lsel); $mamul_LAll = "select count(no) from $mamulcode where gong='Y' $ar1 $sangsearch1"; $mamul_LAll = mysqli_query($connect,$mamul_LAll); $mamul_LAll = mysqli_fetch_Array($mamul_LAll); } /********************************************************************************************************/ ?>
|