Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Sorting albums alphabetically [new]  (Read 3106 times)

0 Members and 1 Guest are viewing this topic.

ixar

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 1
Sorting albums alphabetically [new]
« 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 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 .
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Sorting albums alphabetically [new]
« Reply #1 on: December 30, 2010, 11:13:04 am »

Open your category 'CC (cat 1)' and check if it works there.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.