do you have a module position there? that's what you should use...

No, I don't have module positions there. I have used it as menu item type "Standard Album Layout".

There are many audio pages (one of these pages as an example: http://mojakozmetika.mk/isa/audio-archives-by-category/integrative-medicine ).

I want the latest audio files to be displayed on the top of each page, first (older audio files) added to be displayed at the bottom of each page (newest audio files ascending ordered-older audio files descending ordered of each page). Currently, the order is descending.

Thank you in advance,

well you can use the module positions available on the album page (see here http://www.joomlathat.com/documentation/music-collection/album-profile-in-music-collection-21 ) but this page does not have a module position "at the top". No music collection pages have that position..

It seems that we don't understand each other. Sorry, i might have not explained well.
My question was, how to order the newest audio files so that they will be displayed at the top of the list? For example, on this page http://mojakozmetika.mk/isa/audio-archives-by-category/integrative-medicine. This page is created through the main menu as menu item type "Standard Layout Album" page (I haven't used any module for this purpose).

So, I'm not asking about any modules and module positions, but I'm asking how to make the audio files to "fall down" in order starting from the latest (the newest added, the file with the latest date) at the top and ending with the oldest added (the file with the earliest date).

Thanks

ohhh!!! ok I understand you now!

well, for this you just need to modify the MySQL query that retrieves the song list. do you know MySQL?

the file to modify is /components/com_muscol/models/album.php

I 'm not an expert in MySQL, I have some basic knowledge.
Exactly which line should be changed in that file? or would you like send me that part of the code, modified by you, just to replace it, please?

Thank you,

you need to change the ORDER BY clause on the function bulidQuery(), that's all.

I can't find function bulidQuery() in /components/com_muscol/models/album.php (album.php) or I don't understand something? Can you help me please?

Thank you.

it's misspelled. it's buildQuery

There is not function buildQuery, you can check by your self (in the attachment).
Regards,

try function getSongs()

I am having the same issue. My daughter is drilling me on why her oldest songs are displaying first and her newest ones are at the bottom. "The newest songs should be at the top like itunes dad" (This is what I get to deal with) Anyways, I made the change in the getSongs() function to ' ORDER BY ID DESC '; but it still displays the same way. I am wondering if I need to do anything else to complete this step? I disabled cache so I know it's displaying in real time. Any guidance with this would be most helpful. Thanks,

Adam

Hello Adam,

you did this change on the models/album.php page?

Germinal.

Thanks for such a fast reply! Yes I did it on the album.php file around line 380 under function getSongs (

LEFT JOIN #__muscol_artists as ar ON ar.id = s.artist_id ' .

						' WHERE s.album_id = '.$this->_id.

						' ORDER BY id DESC ';

)

try:

ORDER BY s.id DESC

(notice the s.id instead of just "id")

changed it and still no difference.

that sounds weird.. it should really be as simple as that. you're for sure in the album page, right?

do you want to send me a link to the page so I can check?

http://www.savannahlynne.com/music

thanks. are you able to send me FTP access at support@ joomlathat.com so I can take a look at the code?

yessir sending in 5

Hello Adam,

nevermind the acces, I figured it out.

You're not on the album page...! this is the ARTIST page. specifically, the songs list page.

the file you need to modify is /models/songs.php, line 70.

you need to ORDER BY s.id DESC.

that's it.

awesome. thanks for your help on this

changed and works like a charm! thanks again