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: Title link list  (Read 2661 times)

0 Members and 1 Guest are viewing this topic.

AK_CCM

  • Coppermine regular visitor
  • **
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • Mushroom Hobby Photograph
    • Ent◊l◊ma.de – 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: 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.
Logged

Αndré

  • 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?
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.