Thread geokoordinaten (26 answers)
Opened by Froschpopo at 2006-09-11 06:47

Froschpopo
 2006-09-14 03:52
#34650 #34650
User since
2003-08-15
2653 Artikel
BenutzerIn
[default_avatar]
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

View full thread geokoordinaten