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";
?>
어쩌라구..?
...
즐~
댓글 없음:
댓글 쓰기