Advanced search  


cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: Title link list  (Read 2740 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine regular visitor
  • **
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • Mushroom Hobby Photograph
    • Ent◊l◊ – Rötlinge, Wiesenpilze und andere Schwammerln
Title link list
« on: June 25, 2010, 01:10:18 pm »

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:

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.aid, a.title, b.title atitle from {$CONFIG['TABLE_PICTURES']} a, {$CONFIG['TABLE_ALBUMS']} b where a.aid = b.aid order by a.aid, desc");
I will be glad if anyone could help me.


  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Title link list
« Reply #1 on: June 28, 2010, 02:42:04 pm »

Where exactly do you need help? With the order of the titles?
Pages: [1]   Go Up

Page created in 0.014 seconds with 19 queries.