Sorting listing

[philoo +]

I thank you every body for fast support and ideas to solve problems.

I do not have time to test these solutions today, but I am sure we will find an issue

[cwp +]

Originally Posted by suzkaw

That should be pretty easy. Open includes/classes/kernel/Listings.php and go to line 360:

$listingSQL=$sSQL .' '. $where .' ORDER BY '. $sqlsort .' '. $sortorder;

Change to something like:

$listingSQL=$sSQL .' '. $where .' ORDER BY featured DESC, '. $sqlsort .' '. $sortorder;

Eric, by doing this modification your featured listings will always be on top, and then you can select something else in the first check box where it asks how you want the listings sorted?

[Eric Barnes]

I am not sure I understand your question. Basically with that hack featured listings will be sorted first no matter the user resorts them.

[philoo +]

Originally Posted by suzkaw

I am not sure I understand your question. Basically with that hack featured listings will be sorted first no matter the user resorts them.

It is the answer for my specific usage...

[philoo +]

After some days of experimentation (I launched 68C last week) these solution

PHP Code:

$listingSQL=$sSQL .' '. $where .' ORDER BY featured DESC, '. $sqlsort .' '. $sortorder; 


solve the problem for showing Featured first in category listings but it produce colateral effects everywhere :

- Featured ads are also showed first when asking "last listings" or "top viewed listings" (toplistings.php script)

- Featured ads are also showed first in admin 'manage listings'


.... so I would like to explore the possibility of having FEATURED first showed at the top only when browsing category listings

[hel68c +]

$listingSQL=$sSQL .' '. $where .' ORDER BY featured DESC, '. $sqlsort .' '. $sortorder;

I used this code and it work fine for toplisting but when I look by category, the first page is sort by featured DESC and the rest are list ASC.

look at here to see Welcome on Hobby Classified. Free Hobby ads...

[mgravlee +]

Originally Posted by Eric Barnes

That should be pretty easy. Open includes/classes/kernel/Listings.php and go to line 360:
Change to something like:

$listingSQL=$sSQL .' '. $where .' ORDER BY featured DESC, '. $sqlsort .' '. $sortorder;

When I made the code change I get this when I click on an ad in the list(search functions work OK):

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f.fOrder ASC' at line 1 SQL: SELECT f.fID,sValue FROM class_products_fields AS p, `class_fields` AS f WHERE p.pID='1245' AND f.fSeen='Y' AND p.fID=f.fID f.fOrder ASC in /home/cattleto/public_html/classified_ads/includes/classes/database/mysql.php on line 143

I'm using mySQL5.

[Lhotch +]

Originally Posted by mgravlee

When I made the code change I get this when I click on an ad in the list(search functions work OK):

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f.fOrder ASC' at line 1 SQL: SELECT f.fID,sValue FROM class_products_fields AS p, `class_fields` AS f WHERE p.pID='1245' AND f.fSeen='Y' AND p.fID=f.fID f.fOrder ASC in /home/cattleto/public_html/classified_ads/includes/classes/database/mysql.php on line 143

I'm using mySQL5.

When you start making changes to you script files you really need to slow down and make sure you are following suggestions for your version of 68C. Your sig says your running 4.1.5 but this is a thread for 4.0.

[mgravlee +]

Had a mySQL problem. This code works in v4.1.x.

Check it out on my site.