query($sql); $row = $result->fetch(); if($result->size() > 0){ $loc = $row["name"]; $search = "and local = '".$loc."'"; } } if($_GET["large"]){ $sql = "select * from large_class where id = ".intval($_GET["large"]); $result = $mysql->query($sql); $row = $result->fetch(); if($result->size() > 0){ $loc = explode("~",$row["name"]); if($search == ""){ $search = "and ((large >= ".$loc[0]." and large <= ".$loc[1].") or (large2 >= ".$loc[0]." and large2 <= ".$loc[1]."))"; }else{ $search.= "and ((large >= ".$loc[0]." and large <= ".$loc[1].") or (large2 >= ".$loc[0]." and large2 <= ".$loc[1]."))"; } } } if($_GET["price"]){ $sql = "select * from price_class where id = ".intval($_GET["price"]); $result = $mysql->query($sql); $row = $result->fetch(); if($result->size() > 0){ $loc = $row["name"]; if($search == ""){ $search = "and price = '".$loc."'"; }else{ $search.= "and price = '".$loc."'"; } } } if($_GET["t"]){ if(intval($_GET["t"]) == 1){ if($search == ""){ $search = "and type = '預售'"; }else{ $search.= "and type = '預售'"; } }else{ if($search == ""){ $search = "and type = '成屋'"; }else{ $search.= "and type = '成屋'"; } } } $t = intval($_GET["t"]); if($t == ""){ $t = 0; } $sql = "select * from online where publish = 'Y' and fine_sale = 0 ".$search." order by list_no desc"; $result = $mysql->query($sql); ?> 美學生活
View By || >ALL >預售 >成屋
Search ||