Zipcode Distance

[Ninjakreborn]

Is there a way (in a Mysql Query) to only get zipcode results within a certain distance (Miles) of another zipcode?

 

For example..if you were searching for zipcode 30082...and you wanted to get all results from the database that had zipcodes that were within 20 or 30 miles of the search zip code, is that possible.

[Zane]

http://www.phpfreaks.com/forums/index.php?topic=208965.0

 

example SQL: from http://www.phpro.org/tutorials/Geo-Targetting-With-PHP-And-MySQL.html

SELECT :unit * ACOS( SIN(RADIANS(:lat_from)) * SIN(RADIANS(:lat_to)) + COS(RADIANS(:lat_from))  * COS(RADIANS(:lat_to)) * COS(RADIANS(:long_from) - RADIANS(:long_to))) AS distance

[Ninjakreborn]

Cool, thanks for that. I appreciate it.