forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: evok on May 01, 2005, 10:06:47 pm

Title: sort the album list
Post by: evok on May 01, 2005, 10:06:47 pm

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

Title: Re: sort the album list
Post by: Nibbler on May 01, 2005, 10:21:47 pm

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

- and use ORDER BY aid DESC

Title: Re: sort the album list
Post by: evok on May 01, 2005, 10:40:26 pm

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 '. ?

Title: Re: sort the album list
Post by: Nibbler on May 02, 2005, 07:04:15 pm

You want to change the occurence of

Code: [Select]

' ORDER BY a.pos '.
that appears in the function list_albums(), so that it reads

Code: [Select]

ORDER BY a.aid DESC