Order By Distance

[Anon]

I have an application which will take a zip code and find results within "x" miles, based upon the Longitude and Latitude of the initial zip. I was wondering how to order the results by distance from the user inputted zip code.

I know I need to base the distance upon the initial Longitude and Latitude, but I'm not sure if (or how) I do it in the sql statement or if I can somehow order the results in the while statement or ???

I'm fairly new to PHP and need some pointers. A code example would be greatly appreciated. Thank you!

Mark

[Anon]

How are you getting the distances?

You can order 2 ways, depending on how you get the distances. One is in the SQL statement:

SELECT something FROM table ORDER BY something ASC

Or using PHP's sort functions:

sort($distances); // $distances is an array

Diego