Sorting albums alphabetically

[Criss]

Hi,

Can anyone tell me how can I sort albums alphabetically under category? Modification for version 1.4 doesn't work anymore.

http://joejonasphotos.org

[Joachim Müller]

The instructions in the other thread say you need to replace

Code Select Expand

ORDER BY a.poswith

Code Select Expand

ORDER BY a.titlein index.php in the relevant queries. Did you try that? It's in the code two times - the corresponding queries are

Code Select Expand

        $sql = 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner '
            . ' FROM ' . $CONFIG['TABLE_ALBUMS'] . ' as a '
            . ' LEFT JOIN ' . $CONFIG['TABLE_PICTURES'] . ' as p ' . 'ON a.thumb=p.pid '
            . ' WHERE a.category=' . $cat . $album_filter
            . ' ORDER BY a.pos, a.aid ' . $limit;and

Code Select Expand

    $sql = "SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword, a.alb_hits"
            ." FROM {$CONFIG['TABLE_ALBUMS']} AS a "
            ." LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON a.aid = p.aid AND p.approved = 'YES' "
            ." WHERE a.category = $cat $album_filter GROUP BY a.aid ORDER BY a.pos, a.aid $limit";

[Criss]

Got it! Thanks!