Thread geokoordinaten
(26 answers)
Opened by Froschpopo at 2006-09-11 06:47
HA HA HA fertig !! das wars:
Code: (dl
)
mysql> SELECT name, wohnort, postleitzahl, (ACOS((SIN(RADIANS(48.7667))*SIN(RADIANS(lat))) + (COS(RADIANS(48.7667))*COS(RADIANS(lat))*COS(RADIANS(lon)-RADIANS(9.18333)))) * 6378.388) AS e FROM defaultusers WHERE (ACOS((SIN(RADIANS(48.7667))*SIN(RADIANS(lat))) + (COS(RADIANS(48.7667))*COS(RADIANS(lat))*COS(RADIANS(lon)-RADIANS(9.18333)))) * 6378.388) <= 20 ORDER BY e ASC; sucht im umkreis v. 20 km um stuttgart |