I need someone to build me a mysql query for sorting items by proximity.
I have table A with thousands of entries, they each have a zipcode field. I need to be able to retrieve lets say, 500mile radius from a user input of their zipcode, these listings must be ordered by lowest distance. There is also another table which stores zipcode information, city, state, latitude, longitude, and the zipcode. Also, this needs to be very robust. I'm interested doing this with Spatial Extension for MySQL, or Sphinx-mysql geolocation. If you want me to pick you, please tell me which way is a better approach to handle a lot of data while keeping resources at minimum. I would ultimately like to see this done with Shinx Geolocation, but PM me with your ideas. I won't pick you if you can't tell me which way works best.