What is your DB? (if MySQL your in luck) Store Locator with the code to retrieve locations within a search radius http://code.google.com/support/bin/answer.py?answer=87134&topic=11364 http://code.google.com/support/bin/answer.py?answer=87134&topic=11364#findnearsql
Tip: Geocode (and check) your addresses once and store the lat/lng in the DB - this reduces the need to hit googles gecoders for the same infomation. Mapperz http://mapperz.blogspot.com/ On Dec 10, 4:52 pm, Jack W <[EMAIL PROTECTED]> wrote: > Hello, > I am currently working on a map that will show Bed and Breakfasts near > cities based on their geocoded distance from that city. Allowing the > user to switch between distances. I am able to accomplish this with a > small amount of data only showing B&B's that have set themselves in > the database to that particular city. My problem is that I need to be > able to show all B&B's within 50 miles of a city. > > My code is creating an array with php and sending it to javascript for > processing. The javascript checks the geocode of the B&B and sees if > it is within 50 miles of the city set on the page. > > Can be viewed here:http://hat.org/maptest.php?id=530 > > Javascript:http://hat.org/map/map.js > > My problem is figuring out a way to get to all of the data in the DB, > which is around 100 items, figure out the distance from that city and > if it is even relevant to that city(within 50 miles) and then display > it on the map without taxing Google Maps. I'm really at a loss for > the way to accomplish this with PHP and then in the Google Maps api. > > For each Bed and Breakfast I have: address, geocode, city, zip code. > I have code to figure out the geocode of the city and put it into the > variable sP. > > Any ideas to inspire me? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
