200 AND hotelcity.jyun<300"; $lat_center=38.5; $lng_center=116.9; $size=5;
}elseif($_GET['area']=="huadong"){ $areaset = "AND hotelcity.jyun>300 AND hotelcity.jyun<1000"; $lat_center=31.1; $lng_center=120.1; $size=7;
}elseif($_GET['area']=="huanan"){ $areaset = "AND hotelcity.jyun>1000 AND hotelcity.jyun<1100"; $lat_center=23.4; $lng_center=113.3; $size=5;
}elseif($_GET['area']=="west"){ $areaset = "AND hotelcity.jyun>1100"; $lat_center=34.5; $lng_center=105; $size=4;
}
if($areaset){
$data=array();
$rtn=pg_exec("SELECT DISTINCT ON (hoteldata.city) hoteldata.id,num,hotelcity.city,hotelcity.cityname,lat,lng,jyun FROM hoteldata,hotelcity WHERE hoteldata.city=hotelcity.city $areaset AND lat IS NOT NULL AND lng IS NOT NULL AND num IS NOT NULL AND lat>0 AND lng>0");
$n=@pg_num_rows($rtn);
for($i=0;$i<$n;$i++){
$row = @pg_fetch_array($rtn,$i);
$data[$row['jyun']]['city']=$row['city'];
$data[$row['jyun']]['name']=$row['cityname'];
$data[$row['jyun']]['lat']= $row['lat'];
$data[$row['jyun']]['lng']= $row['lng'];
$data[$row['jyun']]['id']= $row['id'];
}
}
?>
