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 :)