hello to all, i have (actually will have) a table in my Db with data of thousands of stores across the USA, each one containing zip code. right now, when searching for "a store near you" i go through the Db store by store and use a distance between points function (uses lat lng data) to locate the stores which are in radius X around the user's address. my question - is there a way to use the zip info so i can use the sql query to retrieve only a portion of the stores, say from a given state or county. then i would have to use the function on less stores. i have a "state" field as well but this can be tricky if the users lives close to state borders and the store is just across the border in another state. also, in a city like LA or NY i might have hundreds of stores.
the idea (if possible..) is that if a have a "base" zip of say 666 i could do WHERE zip BETWEEN 666+100 and 66-100 and get filtered results. thanx in advance for any attempt to help :-) -- 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.
