Ninjakreborn Posted August 15, 2011 Share Posted August 15, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/244840-zipcode-distance/ Share on other sites More sharing options...
Zane Posted August 15, 2011 Share Posted August 15, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/244840-zipcode-distance/#findComment-1257727 Share on other sites More sharing options...
Ninjakreborn Posted August 15, 2011 Author Share Posted August 15, 2011 Cool, thanks for that. I appreciate it. Quote Link to comment https://forums.phpfreaks.com/topic/244840-zipcode-distance/#findComment-1257735 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.