Sorting Recordset by a calculation between 2 Records
| From: | Vernon | Date: | Tue, 18 Mar 2003 18:22:27 +0000 |
| Subject: | Sorting Recordset by a calculation between 2 Records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-140157@lists.php.net to get a copy of this message | ||
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.
Any ideas?
Thanks