This is a pretty common feature on many websites - like dating or "find a contractor" websites.
You'll enter in your zip code, then you enter in how many miles to "spread out" from this zip code, then the site displays for you all items within a, say, 5 mile radius of your zip code.
So I need to implement this functionality on my website but i have no idea where to start.
I have a database of every zip code in America.
And I have a database of all my plumbers around America
So when someone goes to my website and types in:
ZIP: 00501 Radius: 5
I need to show them all the plumbers I got within a 5 mile radius of their zip code.
Anyone got any ideas on how I would code that?
Since I have the longitude and latitude of all the zip codes, perhaps i'd have to do some sort of geometric heuristic?
I'm sure this is a classic computer science problem.
But I was only a computer science minor...