[Naver Blog 2004/05/29 04:53] 내 평생 가장 테러블한 if else 문..

if (($searchname !="") || ($searchtel !="") || ($searchid1 !="") || ($searchid2 !="") || ($searchaddress !="") || ($searchcontract !="") || ($searchbill !="")) {

$query = "select c_customno, c_name, c_tel, c_addr from customer where";

if ($searchname !="") $query .= " c_name like '%".$searchname."%'";

if (($searchname !="") && ($searchtel !="")) $query .= " and c_tel like '%".$searchtel."%'";

else $query .= " c_tel like '%".$searchtel."%'";

if ((($searchname !="") || ($searchtel !="")) && ($searchid1 !="")) $query .= " and c_idno like '%".$searchid1."%'";

else $query .= " c_idno like '%".$searchid1."%'";

if ((($searchname !="") || ($searchtel !="") || ($searchid1 !="")) && ($searchid2 !="")) $query .= " and c_idno like '%".$searchid2."%'";

else $query .= " c_idno like '%".$searchid2."%'";

if ((($searchname !="") || ($searchtel !="") || ($searchid1 !="") || ($searchid2 !="")) && ($searchaddress !="")) $query .= " and c_addr like '%".$searchaddress."%'";

else $query .= " c_addr like '%".$searchaddress."%'";

if ((($searchname !="") || ($searchtel !="") || ($searchid1 !="") || ($searchid2 !="") || ($searchaddress !="")) && ($searchcontract !="무관")) $query .= " and c_contract = '".$searchcontract."'";

else $query .= " and c_contract = '".$searchcontract."'";

if ((($searchname !="") || ($searchtel !="") || ($searchid1 !="") || ($searchid2 !="") || ($searchaddress !="") || ($searchcontract !="")) && ($searchbill !="무관")) $query .= " and c_bill = '".$searchbill."'";

else $query .= " c_bill = '".$searchbill."'";

}

else $query = "select c_customno, c_name, c_tel, c_addr from customer";

?>

어쩌라구..?

...

즐~

댓글 없음:

댓글 쓰기