How to get the nearest place from database i am using drupal 6 gmap and location module to save the users latitude and longitude in database. I need to create a service in which i am returned the places list in the order of nearest first. I have all the rest of the code ready and would be all set to go if you guys could share the SQL
You have to play around location views. Add a filter and argument to sort by proximity.