the only way to achieve this would be actually changing the query that retrieves this data on the model file... are you skilled in MySQL ?

hi germi. could you guide me to the mysql model file (which directory is it in)?

Yes I can find my way in MySQL and PHP ... just please guide me with what I have to change...

Thanks

the file is /components/com_muscol/models/artist.php just look where the ORDER BY clause is and put yours!

Can you guide me please to the part of code in that file that changing it will result showing the tracks of an album to be sorted by date of adding ..

I see select statements that I can edit sort by but which one I should modify .. more information about the specific part of code that I should modify is appreciated..

I thought you are a programmer...!

the ORDER BY clause is near line 214

' ORDER BY year,month ';

that's whay you need to change for whatever you want!

I am a programmer what kept me puzzled that it is already sorting by year, month ... I wanted to make sure we are talking about the same thing ...

Attached you will find a picture of the details of an album ...
here you will find tracks ... In our case a track will be added every week ... we want the last track to show as number 1 instead of 10 ... the recent added to show first ...

I just want to make sure this is what you are guiding me to ...

ok I thought you were talking about artist page. sorry, my mistake

in this case what you need is in models/album.php file, line 342 approx

' ORDER BY s.disc_num,s.num ';

in this case you want to order by s.added

Thank you so much ... that was a great help ..