At 05:59 PM 10/8/2005, you wrote:
>I was wondering if anyone might have a canned query I could use for the
>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.
>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
>Any suggestions? This query if completely possible within MySQL is well
This has been discussed quite a lot. Take a look at
for more info.