forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: AK_CCM on June 25, 2010, 01:10:18 pm

Title: Title link list
Post by: AK_CCM on June 25, 2010, 01:10:18 pm

A few years ago I added a title link list of all images (http://forum.coppermine-gallery.net/index.php/topic,33000.0.html) to a CPG 1.4.x installation. Now I want a title link list for CPG 1.5.x in which the titles are subdivided by albums as you can see at the attached screenshot or live here: http://www.pilzteam-bayern.de/galerie/inhalt.php

But how could I change the code so CPG shows the title links ordered by title and do not change the sequence of the albums? Also I want that CPG groups identical entries together into a single entry.

Code: [Select]

$result = mysql_query("SELECT a.pid, a.aid, a.title, b.title atitle from {$CONFIG['TABLE_PICTURES']} a, {$CONFIG['TABLE_ALBUMS']} b where a.aid = b.aid order by a.aid, a.pid desc");
I will be glad if anyone could help me.

Title: Re: Title link list
Post by: Αndré on June 28, 2010, 02:42:04 pm

Where exactly do you need help? With the order of the titles?