title: php/mysql zip code proximity search
body: <p>I'm just looking for suggestions on the best way to do this... </p>
  
  <p>I need to create a search function that searches for "users" within a 50 mile radius of a zip code. I have a zip code table that contains all the U.S. zip codes with their latitude/longitude but I'm just trying to figure out the best way to structure and query my data...</p>
  
  <p>Should I add latitude/longitude columns to the users table and query it for all the users within the radius of the given zip code? Or should I query the zip codes table for all the zip codes that fall within the radius then query the users table for all the users with the results(zip codes)? Or... ??? I am open to any suggestions at this point!</p>
  
  <p>Thanks!</p>