anyone has any idea about the logic behind looking up businesses in google maps. if i say "pizza near 92109" in google maps, i put markers around the zipcode for pizza places. I was trying to do something same with range too. say " 25 miles with in the radius of zipcode" .. it is possible to find the distance between 2 zipcodes.. if i say " pizza near 25 miles of 92109" one option i can think of is finding all pizza location in my database and find the distance of the business from the specified zipcode and if it falls with in the radius, display it.. I didnt really like that idea that much.
other option would be add region for each business, find the region from the zipcode and search for matching business in the region..
I would love to hear more ideas or suggestions on the same.