Thanks for the clarification. I got it figured out.
I too was using the hard-coded lat/long for the Burbank A/P since I am familiar with its location. I thought I could test my values with your defaults, but something was goofed up on my end. I don’t know what it was. I changed the values to my own lat/long, and somehow that magically fixed the problem.
Thanks again for you response and your code. It was a life-saver!!!
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::*/
/*:: :*/
/*:: this routine calculates the distance between two points (given the :*/
/*:: latitude/longitude of those points). it is being used to calculate :*/
/*:: the distance between two zip codes or postal codes using our :*/
/*:: zipcodeworld(tm) and postalcodeworld(tm) products. :*/
/*:: :*/
/*:: definitions: :*/
/*:: south latitudes are negative, east longitudes are positive :*/
/*:: :*/
/*:: passed to function: :*/
/*:: lat1, lon1 = latitude and longitude of point 1 (in decimal degrees) :*/
/*:: lat2, lon2 = latitude and longitude of point 2 (in decimal degrees) :*/
/*:: unit = the unit you desire for results :*/
/*:: where: 'm' is statute miles :*/
/*:: 'k' is kilometers (default) :*/
/*:: 'n' is nautical miles :*/
/*:: united states zip code/ canadian postal code databases with latitude & :*/
/*:: longitude are available at http://www.zipcodeworld.com :*/
/*:: :*/
/*:: For enquiries, please contact sales@zipcodeworld.com :*/
/*:: :*/
/*:: official web site: http://www.zipcodeworld.com :*/
/*:: :*/
function distance($lat1, $lon1, $lat2, $lon2, $unit) {
$theta = $lon1 - $lon2;
$dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
$dist = acos($dist);
$dist = rad2deg($dist);
$miles = $dist * 60 * 1.1515;
$unit = strtoupper($unit);
if ($unit == "K") {
return ($miles * 1.609344);
} else if ($unit == "N") {
return ($miles * 0.8684);
} else {
return $miles;
}
}
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "m") . " miles<br>";
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "k") . " kilometers<br>";
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "n") . " nautical miles<br>";
This solution for a zip code proximity search was working for me until my hosting provider upgraded to mySQL 4.1.14. Now I am having difficulty with “order by dist”.
How do I code this so I can still “order by dist” in the new version of mySQL.