Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *, ( 3959 * acos ( cos ( radians(".$city[0]->latitude.") ) *
- cos( radians( latitude ) ) * cos( radians( longitude ) -
- radians(".$city[0]->longitude.") ) + sin ( radians(".$city[0]->latitude.") )
- * sin( radians( latitude ) ) )) AS distance FROM cities WHERE distance <= 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
