forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: burlington on June 21, 2012, 06:12:58 pm

Title: 'Order by title' problem
Post by: burlington on June 21, 2012, 06:12:58 pm
Running version 1.5x with numerous albums within a small number of categories. I have been asked if the albums can be ordered (sorted) by title (name) within each category. I have followed earlier advice to amend the index.php file to show 'order by title' but to no avail.

Any advice would be welcome please. I thought that there was a function within the admin system to achieve this without file editing but I can't find it.

Thanks

Martin



Title: Re: 'Order by title' problem
Post by: Αndré on June 21, 2012, 10:42:55 pm
I have followed earlier advice to amend the index.php file to show 'order by title'
Please post a link to that thread.
Title: Re: 'Order by title' problem
Post by: burlington on June 22, 2012, 10:36:51 am
Sorry.

Here it is:

http://forum.coppermine-gallery.net/index.php/topic,65634.msg326187.html#msg326187

Dated 21/6/2010

Martin
Title: Re: 'Order by title' problem
Post by: Αndré on June 25, 2012, 10:48:43 am
Joachim's instruction works as expected for me. You have to replace
Code: [Select]
ORDER BY a.pos, a.aidwith
Code: [Select]
ORDER BY a.title, a.aidtwice, in index.php
Title: Re: 'Order by title' problem
Post by: burlington on July 05, 2012, 03:22:10 pm
Thank you for your help.

Apologies for the delay in replying but I have been away. Your suggestion works fine and I am grateful.

However, I have now been asked about sorting by title within categories in the album manager file /albmgr.php BUT I can't seem to get it to do what I want it to.

Can you help again please?

Thanks

Martin
Title: Re: 'Order by title' problem
Post by: Αndré on July 05, 2012, 03:29:09 pm
sorting by title within categories in the album manager file /albmgr.php
Sorry, but I don't understand what you want to do.
Title: Re: 'Order by title' problem
Post by: burlington on July 05, 2012, 06:16:29 pm
Andre

Thanks

If the Administrator wants to edit an album within Album Manager, ..../gallery/albmgr.php?cat=*, and there are a lot of albums within a Category, the albums are not sorted automatically by title order and so he/she has to read down the list until they find what is wanted.

The list IS now sorted by Title order in the public view of the albums BUT not within Album Manager.

Martin
Title: Re: 'Order by title' problem
Post by: Αndré on July 05, 2012, 07:58:04 pm
So your current request is to sort also the album manager by title, right?
Title: Re: 'Order by title' problem
Post by: burlington on July 05, 2012, 10:14:50 pm
Yes please.
Title: Re: 'Order by title' problem
Post by: Αndré on July 06, 2012, 10:05:17 am
Open albmgr.php, find
Code: [Select]
ORDER BY pos ASCand replace with
Code: [Select]
ORDER BY title ASC(twice).
Title: Re: 'Order by title' problem
Post by: burlington on July 07, 2012, 08:32:44 am
Works perfectly.

Very many thanks

Martin
Title: Re: 'Order by title' problem
Post by: Αndré on July 08, 2012, 10:43:16 am
Please
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.