sort the album list

[evok]

hey.. how can i sort the album list on the startpage- that the last uploaded album is displayed first? or is it not possible?

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=1379.0

- and use ORDER BY aid DESC

[evok]

thanks for your reply.. but ive got a problem: the index.php includes two lines with ' ORDER BY a.DESC '. - and when i change them i get a databes error. do you know which line i have to change? and is this the right syntax: ' ORDER BY a.DESC '. ?

[Nibbler]

You want to change the occurence of

Code Select Expand

' ORDER BY a.pos '.

that appears in the function list_albums(), so that it reads

Code Select Expand

ORDER BY a.aid DESC