Find Surrounding Addresses

[ikmyer]

I am working on a site and in one section it lists a bunch of addresses on a map...

 

Any ideas of the best (or most effective/efficient) way to find addresses in the database that are surrounding a set point on the map.

 

I have access to full address (address, city, state, zip) and Google maps Lat and Long coordinates.

 

Like now do they do the the "Find x within 10 miles... 25 miles... 50 miles... ?

 

Thanks!

 

PS. i don't need the code... i can do that part... just need help with the idea/process.

[revraz]

http://www.douglaskarr.com/2007/09/15/calculate-distance/

[Northern Flame]

Good post revraz!

I just went through that article and tried out the script

and its very helpful 

[ikmyer]

thanks for the link revraz... it looks promising.

 

 

[ikmyer]

ok... so i got the function working normal.

 

When i try to test the sql i get the following...

SELECT * , (((acos( sin( ( 38.502147 * pi( ) /180 ) ) * sin( (
`g_lat` * pi( ) /180 ) ) + cos( ( 38.502147 * pi( ) /180 ) ) * cos( (
`g_lat` * pi( ) /180 )
) * cos( ((-117.022694 - `g_long`) * pi( ) /180 )))) *180 / pi( )) *60 * 1.1515
) AS distance
FROM users_maps
WHERE distance < 2

MySQL said: Documentation
#1054 - Unknown column 'distance' in 'where clause'

 

 

If i take out the "WHERE distance < 2" it just returns all results with a distance field which looks to be correct.  any ideas ?