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: order album by last added and album pos column always 0 (zero)  (Read 3057 times)

0 Members and 1 Guest are viewing this topic.

xam

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
order album by last added and album pos column always 0 (zero)
« on: February 20, 2005, 11:57:51 am »

Hi,

I was trying to use the tip posted at http://forum.coppermine-gallery.net/index.php?topic=1379&postdays=0&postorder=asc&highlight=order+date&start=0
about adding DESC to get the album list displayed by "created last".

But this does not work since all albums created via the xppublish mechanism seem to to always set pos to 0 (zero).
Albums created by hand seem to work ok.

Thus I "hacked" my way around it and put in order by a.aid DESC instead (which now relies on aid to always be higher on newer albums).

But anyhow this only give me "half" of what i want.
I would like the album list to be sorted by "last added picture date" - so most recent additions comes first.

Any tips on doing that ?

Best regards,
Max
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.