Re: Sorting Recordset by a calculation between 2 Records

Vernon wrote:

I am calculating distances between to record's zip codes using php and have a need to sort the recordset by that value. How do I do something like this? I mean it's not a value in the table that I can use the SQL ORDER BY statement. I want to be able to have the distances closest to the individual first.

When you say "using php" I'm assuming that this means you are not doing the calculation at the database, but rather in your PHP code. Use the distance you've calculated as the numeric index of an array, pointing to the record that corresponds to that distance. Erik