Sort order

[Jim Oaks]

When I go in my classifieds and choose ZipCode for the sort order, it's all out of wack:

Ford Rangers For Sale - TRS Classifieds

The ads aren't showing up in relation to their zip codes.

[Chuck S]

its ordering by zipcode of the actual ads which has nothing to do with distance or anything so not sure what you mean by out of whack as I think you must think it means distance not the actual numerical zipcode.

[Jim Oaks]

I figured it would sort by distance from the users zip code (like other classifieds). I really don't know why anyone would want to organize ads just by numerical zip code.

[Chuck S]

well it is not really possible to sort results on a mysql field that does not exist. Sorting is done on a field in the products table like title,extra fields,rating etc. Results are sorted when returned by the query. Its basically in mysql and order statement like

ORDER BY title DESC

Distance calculations for zipcode are done after the sorted results are returned.