1. peacetree
  2. Support
  3. Tuesday, March 21 2017, 11:47 AM
Is there a way to retrive users from a certain area by a custom sql command to show in userlist by useing geo data?
admin Accepted Answer
Admin
Hi,
yes this is possible, see an example at https://www.easy-profile.com/support/custom-sql-where-to-preset-profiles-within-area-city-and-radius.html#reply-7556

Notes:
- "6371" is a constant for Kilometers, is you want to use Miles for your radius then the constant is "3959".
- In the example we assumed Google Map field have alias called "map", so we use fields with name "map_lat" and "map_lng". You need to replace latitude and longitude names with your values, so for example if your field have alias like "address" then you should use "address_lat" and "address_lng"
  1. more than a month ago
  2. Support
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.