Title link list

[AK_CCM]

A few years ago I added a title link list of all images 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 Expand

$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.

[Αndré]

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