Đang Thực Hiện

126200 sort by distance calculation

I have a program that provides a database of business listings based on search criteria. If you add your zip code to the search criteria the program will calculate the distance between your zip code and each of the business listings and display that calculation in miles in the results.

What I need is the ability to sort the search results by the distance calculation. Since the distance is not stored in the database anywhere I cant find a way to do it.

Basically I just need to know if it can be done and how much to get it done.

You can view the code that does the distance calculation here [url removed, login to view]

That code basically provides an array of zip codes that are within a specified distance of the zip code you choose. My script matches the business listings (zipcodes) in my database with the zips in the array and displays the results.

let me know if you have any questions.


Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: sort sort sort, sort sort, sort array c, distance zip code, mysql sort, sort criteria, cant find, distance search, distance calculate, program sort, mysql distance, program sort content, php mysql script calculation, php mysql calculation script, php sort, php search zip code script, distance search script, php array add, distance calculation, php calculation script, calculate distance php, calculation script php, php mysql calculate, php script zipcodes, zip zip calculation

Về Bên Thuê:
( 26 nhận xét ) Centennial, United States

ID dự án: #1872367