My db is in fact MySQL. Thanks for the link, it looks like just what I need. I'll post back with my progress.
On Dec 10, 12:35 pm, mapperzUK <[EMAIL PROTECTED]> wrote: > What is your DB? (if MySQL your in luck) > > Store Locator with the code to retrieve locations within a search > radiushttp://code.google.com/support/bin/answer.py?answer=87134&topic=11364http://code.google.com/support/bin/answer.py?answer=87134&topic=11364... > > 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. > > Mapperzhttp://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 -~----------~----~----~----~------~----~------~--~---
