forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 themes (visuals) => Topic started by: ixar on December 24, 2010, 07:42:48 am

Title: Sorting albums alphabetically [new]
Post by: ixar on December 24, 2010, 07:42:48 am

Hi .

I'm trying to sort the albums displayed on the main page , alphabetically . [and failing]

The solution provided here (http://forum.coppermine-gallery.net/index.php/topic,65634.0.html) didn't work .
I have replaced 2 occurrences or "ORDER BY a.pos" with "ORDER BY a.title" .

Code: [Select]

        $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.title, a.aid ' . $limit;


Code: [Select]

    $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.title, a.aid $limit";

Any other ideas ?
Can't link to website , it's currently on localhost .
Attaching screenshot .

Title: Re: Sorting albums alphabetically [new]
Post by: Αndré on December 30, 2010, 11:13:04 am

Open your category 'CC (cat 1)' and check if it works there.