Display order of Ads

HotAir · (#1)

Hi,
I'm building a business directory instead of classified ads. Because of this, I need to have the listings appear in alphabetical order (by Title). I have two listing packages, and one is set to always be featured so those appear above the others. I need each group (the featured listings and the non-featured ones) to be alphabetized within their own group.

How can I accomplish this?

Thanks!

**juven14** · (#2)

There are 3 files that display results: category.php, toplistings.php, and searchresults.php

You will need to alter the order by clause, here is the one for searchresults.php:

PHP Code:


		
			
$sSQL .= " ORDER BY ".MAIN_PRODUCT_SORT." ".MAIN_PRODUCT_SORT_OPTION.", p.dateadded DESC";

Then add in: p.title