Print

[ixar]

Hi .

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

The solution provided here 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 .

[Αndré]

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