Tuesday, February 9, 2010

Webs Developer

PHP, Ruby Rails, JavaScript, AJAX and other bits ‘n pieces…

MySQL - Zip codes: latitude, longitude, distance

Posted by web slinger on June - 29 - 2009

The premise goes like this: so you have a user database with a bunch of people who signed up for your service, which includes the user’s zip code. Now you want to write a query so you can show user A all the other users in your database that are within, say, 10 miles of her zip code.

Share and Enjoy:
  • Reddit
  • Digg
  • Slashdot
  • StumbleUpon
  • TwitThis
  • Technorati
  • del.icio.us
  • Facebook
  • Fark
  • Google

Continue reading over at dzone...

Add A Comment