MySQL Proximity Search Query

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: Geolocation, MySQL, PHP, Web Search

See more: mysql geolocation query, build mysql query, best web search, query table, mysql query, mysql search table, latitude longitude table, city state radius, distance search, proximity search mysql, mysql php state city, mysql query php, user geolocation, city radius search php, php mysql longitude, mysql sphinx, search radius mysql php, mysql distance, php sphinx mysql, search city zipcode, geolocation proximity, mysql longitude latitude, distance table, state city mysql, radius search php mysql

About the Employer:
( 1 review ) Philadelphia, United States

Project ID: #4010922

9 freelancers are bidding on average $172 for this job


Dear Sir, We would love to get this opportunity of working with you. We have implemented such searches in existing projects and can assure you that we will be able to implement it in your website. Regards Netz More

$250 USD in 5 days
(341 Reviews)

Hi, I have done such work. Map expert and quite well understand Geo location concepts. Please check ur PMB. Regards.

$200 USD in 5 days
(19 Reviews)

Hi, I have experience with same kingd of work. I can do this perfectly, Please check PMB for more details,

$200 USD in 3 days
(27 Reviews)

Hello, My solution is a custom one. I have created the fastest zip distance calculator in PHP(check site in PMB). I would use my zip codedatabase, with a custom made cache and feed the results to your site in the best More

$160 USD in 1 day
(45 Reviews)

Hello there, expert Web developer here, ready to help you. Thanks

$100 USD in 1 day
(14 Reviews)

Hello, I can help.

$250 USD in 2 days
(5 Reviews)

please see pm

$200 USD in 2 days
(5 Reviews)

i can do it, i am very expert sql language let's start

$40 USD in 3 days
(0 Reviews)

Dear sir; I'am expert person of database administration and have well knowledge of SQL and MySQL.

$150 USD in 2 days
(0 Reviews)