两坐标点间距离公式

6378.137 * 2 * asin(sqrt(pow(sin((lat1*pi()/180 - lat2*pi()/180)/2),2) + cos(lat1*pi()/180)*cos(lat2*pi()/180)*pow(sin( (lng1*pi()/180 - lng2*pi()/180)/2),2)))

2 * 6378.137 * asin(sqrt(pow(sin(pi()*(lat1 - lat2)/360),2) + cos(pi()* lat1 /180)*cos(lat2*pi()/180)*pow(sin(pi()*(lng1 - lng2)/360),2)))

au_around

==========================

id  ===  aname === blng === blat

==========================

$blat = $_GET["bdlat"];
$blng = $_GET["bdlng"];

$sql = "select *,(2*6378.137*ASIN(SQRT(POW(SIN(PI()*(".$blat." - blat)/360),2)+COS(PI()* ".$blat." /180)*COS(blat *PI()/180)*POW(SIN(PI()*(".$blng." - blng)/360),2)))) as juli from au_around order by juli asc limit 0, 20";