At 05:59 PM 10/8/2005, you wrote:
>I was wondering if anyone might have a canned query I could use for the
>following scenario.
>
>I need to search for a list of locations within a certain distance of a user
>given zip code and order them by driving distance calculated from a table of
>zip codes containing lon and lat info from zipwise.
>
>Example:
>
>1. I enter my zip of 85050
>2. enter a range in miles
>3. search a table of establishments within x miles from step 2
>4. list top ten within range of step 2 ordered by distance.
>
>For the establishments I have the zip codes and as I said I have the zipwise
>tables.
>
>Any suggestions? This query if completely possible within MySQL is well
>above me.
>
>
>
>Thanks
>
>Steffan
Steffan,
This has been discussed quite a lot. Take a look at
http://www.google.com/search?hl=en&lr=&q=mysql+distance+zip+code&btnG=Search
for more info.
Mike
