Posted by homepricemaps@gmail.com on 06/24/06 16:57

sure the code is this

$query = "SELECT * FROM homepricemaps where salesdate >= '" . $date2
.."' AND salesdate <= '" . $date1."' AND citystate = '" . $input ."'
order by address ";


$result=mysql_query($query);
while($row = mysql_fetch_array($result))
{

echo "var point = new GPoint(" . $row['lon'] . ","
.. $row['lat'] . ");\n";
echo "var marker = createMarker(point, 'Address: ".
$row['address'] . " ".$row['city']." ".$row['state']."<br>Sale Price:
$". $row['salesprice'] . "<br>Zipcode: " .

$row['zipcodes'] . "<br>Sqft:" . $row['squarefeet']
.. "<br>Sales Date: " . $row['salesdate'] . "<br>Year Built: " .
$row['yearbuilt'] . "<br>Bedrooms: " . $row['bedrooms'] ."<br>" .
$mortgagecalculator ."<br>" . $homelisturl . "<br>" . $mortgagequotes .
"<br>" . $realtorlist . "<br>"."','" . $row['address'] . "
".$row['city']." ".$row['state']."');\n";


echo "map.addOverlay(marker);\n";



}

[Back to original message]