I am using the following function from phpclasses.org.
How can I gues this to return also the distance for each zip code?
PHP Code:function inradius($zip,$radius)
{
$query2="SELECT * FROM zips WHERE zip='$zip'";
$row = $db->get($query2);
$lat=$row["lat"];
$lon=$row["lon"];
$query2="SELECT zipcode FROM zips WHERE (POW((69.1*(lon-\"$lon\")*cos($lat/57.3)),\"2\")+POW((69.1*(lat-\"$lat\")),\"2\"))<($radius*$radius) ";
$result = $database->query($query2);
if($result->count()<>0) {
while($row = $result->fetch()) {
$zips[$i]=$row["zipcode"];
$i++;
}
}
}else{
return array();
}
return $zips;
}







Bookmarks