This one will be a challenge.
I have a table in my database of cities. They all have a geo lat and lon coordinate in the same row. That location is central of the city.
In a second table, I have a list of stores. Each store has a geo lat/lon of it's location.
What I want is when someone searches a city. Los Angeles for example. It want it to return all stores within a 100m radius of the city lat/lon location.
Any ideas for a starting point?