echo '
Rental Guest
';
echo " ";
echo " ";
echo " ";
$docdata = "\n\n";
$prop = $_GET['pid'];
if ($prop) {
$select_prop = "WHERE pd.pid = '$prop'";
} else {
$select_prop = '';
}
$resultmap = $dbh->getdata_table(
"SELECT pd.pid,
pd.address,
pd.description,
pd.city,
pd.zip,
pd.beds,
pd.baths,
pd.rent,
pd.latitude,
pd.longitude,
pi.image_name
FROM property_data pd
LEFT JOIN property_images pi ON pd.pid = pi.pid
$select_prop
GROUP BY pd.pid"
);
$landmap = $dbh->getdata_table("select * from landmarks");
if($resultmap){
foreach($resultmap as $res){
if($res->latitude!=0&&$res->longitude!=0){
//echo "latitude _ $res->longitude\" name=\"markposition\">";
$inf=" | Listing #".pid_to_listing($res->pid)." Beds: $res->beds Baths: $res->baths";if($res->rent!=0){$inf.=" Rent: ".number_format($res->rent);}$inf.="
| ";//Details
$inf=htmlentities($inf);
$markType="home";
$docdata.="latitude\" lng=\"$res->longitude\" info=\"$inf\" marktype=\"$markType\" />\n";
// echo "";//marker info
}
}
}
if($landmap){
foreach($landmap as $res){
if($res->latitude!=0&&$res->longitude!=0){
//echo "latitude _ $res->longitude\" name=\"markposition\">";
$inf=" | $res->address $res->city, Arizona $res->zip Description: $res->description | ";//Details
$inf=htmlentities($inf);
$markType="landmark";
$docdata.="latitude\" lng=\"$res->longitude\" info=\"$inf\" marktype=\"$markType\" />\n";
// echo "";//marker info
}
}
}
$docdata.="";
$filename = "mapdata.xml";
$fsz = filesize($filename);
$fh = fopen($filename,"w");
if(fwrite($fh,$docdata)==FALSE)echo "Cannot write to file";
fclose($fh);
?>
|