0
How can I make the order of playlists to be most recent on the top in the playlist page. We are using Joomla 3.4.5 and Muscol 2.4.8.
Responses (4)
  • Accepted Answer

    Thursday, December 10 2015, 09:38 AM - #Permalink
    0
    You would need to make a small code tweak on file /components/com_muscol/models/playlists.php
    You need to change the order in the MySQL query.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 10 2015, 02:26 PM - #Permalink
    0
    So, the query I need to change is:
    $this->query = ' SELECT pl.*,us.name as user_name FROM #__muscol_playlists as pl '.
    ' LEFT JOIN #__users as us ON us.id = pl.user_id ' .
    ' WHERE pl.user_id = '.$this->user->id
    ;
    by adding an "ORDER BY" .

    What is the variable I need to use for the ordering? Can you please help me.

    Thank you,
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 10 2015, 04:28 PM - #Permalink
    0
    ORDER BY pl.id DESC
    The reply is currently minimized Show
  • Accepted Answer

    Friday, December 11 2015, 02:12 AM - #Permalink
    0
    That did it! Thank you for your help.
    The reply is currently minimized Show
Your Reply