Print

[antisa33]

Hello
I enjoy a lot the coppermine gallery thank you!!
I have a lot of albums (171) and they are not sorted.
I have tried to sort them by hand by it's very long to do that and it's not automatic.
Where can i modify a file to sort alphabetically all the albums on the main page (index)?
Thank you!!
Isa

[havoc615]

I think you'd replace:

Code: [Select]

$sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.

           'filename, url_prefix, pwidth, pheight '.

           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.

           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.

           'ON a.thumb=p.pid '.

           'WHERE category='.$cat.$album_filter.

           ' ORDER BY a.pos '.

           $limit;In index.php with:

Code: [Select]

$sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.

           'filename, url_prefix, pwidth, pheight '.

           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.

           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.

           'ON a.thumb=p.pid '.

           'WHERE category='.$cat.$album_filter.

           ' ORDER BY a.title '.

           $limit;
You probably have to do it twice, in addition, by the way the codes written, it looks like albums with categories might be after albums without. So they'd sort individually? Im sure you motly have all one way or the other though. Lemmie know how it goes.

[antisa33]

Thank you havoc615 It's exactly that !!
Thanks !!