Filter Database from Lat/Lng epicenter + 10km radius

Hi Everyone

I’m wondering how I can filter my database using a specific lat/lng point as it’s epicenter?

I’m using the google maps tutorial by Yisrael here and this works great, this is where I pull the lat/lng from. Then, when I onClick in the repeater from the tutorial the lat/lng of the selected place is set to text on my page:

Longitude = text1
Latitude = text2

I then have a repeater underneath showing options of places connected to a database. My database is set up with two fields, one called Longitude, one called Latitude. I would then like to filter my database by points that lie within 10 km of the long/lat that displays in text1 and text2.

Is there a way of doing this?

Many thanks :slight_smile:

Thomas

Nudge