Default Sort in showlistings.tpl.php

[eschulze]

I have found where I can modify the default sort in the following files:

category.php
searchresults.php

Here is the problem. I followed a mod found on this site to display an extra user registration field on the showlistings page by adding u.extra to the query. That is working perfect. I want the default sort when the page display to sort by "u.extra ASC" ... I entered that on each of the pages, but it does not seem to be working properly. My defined sort is by featured listings.

Here is the code and a link for each page. You will see that clearly the pages are not sorting by the u.extra field which is "School/Organization":

category.php (My Category Listing Page)

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", u.extra ASC";

searchresults.php (My Search Results Page)

$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", u.extra ASC";

Does anyone have a suggestion on how to make this work? If you click on the header it will sort it correctly, but not when the page comes up.

[Eric Barnes]

I think you need to put your new sort order first.

For example:
ORDER BY u.extra ASC, ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION."

[eschulze]

That fixed the sort, but now the featured ads don't display at the top which won't work. Part of our marketing is that the featured ads display at the top of each category page. Any other suggestions?