+ Reply to Thread
Results 1 to 7 of 7

Thread: Featured Items on top in categories

  1. #1

    Exclamation Featured Items on top in categories

    Hello, I'm having trouble changing the order of listings in categories. Currently the featured items are all at the top but we would like the newest listings in the category to show at the top.


    In the old version of flynax 4.6.2 I was able to change this by editing rllistings.class file

    Changing
    $sql .= "ORDER BY "'Featured' desc;

    To this
    $sql .= "ORDER BY ";

    Now in version 4.7.1 this change no longer works and gives an error.

    Any idea on how to fix this in the new version?

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Hello,

    you should also remove comma below this line in sorting cases which looks like

    sql .= ", ..."

  3. #3
    Also you can use:

    PHP Code:
    Only registered members can view the code
    Viktor,
    Flynax technical department,
    Best wishes.

  4. #4
    Thanks guys, worked perfectly!

  5. #5
    So after updating to 4.7.1 I noticed that the order wasn't correct for the listings, it disabled the featured ads from being up top but didn't order them from newest ads.
    I had to use this code to make it show newest ads but I'm unable to sort them, is there a way to have sorting and newest ads?

    Code:
    Only registered members can view the code.
    Last edited by Robert Engelke; April 19, 2019 at 03:30 AM.

  6. #6
    Senior Member
    Join Date
    Mar 2019
    Location
    Philadelphia, PA, USA
    Posts
    120
    Quote Originally Posted by Robert Engelke View Post
    So after updating to 4.7.2 I noticed that the order wasn't correct for the listings, it disabled the featured ads from being up top but didn't order them from newest ads.
    I had to use this code to make it show newest ads but I'm unable to sort them, is there a way to have sorting and newest ads?

    Code:
    Only registered members can view the code.

    4.7.2 was released?

  7. #7
    Sorry, that was a typo. I corrected the version number.

+ Reply to Thread