|
If Classifieds search was changed to use temp table records like Photopost it would be much easier.
The search records could then store the distance in a field and this could be sorted on. Would just need the distance calculation done in mySQL at run time on the first search.
The other way of course would be to run the calculation on *every* search / category view. Though this might be quite costly, I'm not sure how much CPU time that would take. The benefit though would be it could be used on category viewings too, not just searches.
|