MySQL Proximity Search Query

AWARDED
Bids
9
Avg Bid (USD)
$172
Project Budget (USD)
$30 - $250

Project Description:
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.

Skills required:
Geolocation, MySQL, PHP, Web Search
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 5 days
Hire ashwanii
$ 200
in 5 days
$ 200
in 3 days
$ 160
in 1 days
$ 100
in 1 days
$ 250
in 2 days
Hire Navig8
$ 200
in 2 days
Hire thilinabn
$ 150
in 2 days
Hire vbmusta
$ 40
in 3 days