superKaRaRa.com
New Member
I am writing a site that basically looks for places within a 25 mile radius of a lat and long using php and mysql.I am wondering how something like this would work?I would pass a lat and long to the scrip and have it pull out only locations that are within 25 miles of the lat and long from my Database of locations.What is the best way to do this?EDIT:I found this code for calculating the distance between 2 points.\[code\] 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; }}\[/code\]Is ther a way to do this calc in the MYSQL look up so I can only return if miles =< 25?