'Order by title' problem

[burlington]

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

[Αndré]

I have followed earlier advice to amend the index.php file to show 'order by title'

Please post a link to that thread.

[burlington]

Sorry.

Here it is:

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

Dated 21/6/2010

Martin

[Αndré]

Joachim's instruction works as expected for me. You have to replace

Code Select Expand

ORDER BY a.pos, a.aid
with

Code Select Expand

ORDER BY a.title, a.aid
twice, in index.php

[burlington]

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

[Αndré]

sorting by title within categories in the album manager file /albmgr.php

Sorry, but I don't understand what you want to do.

[burlington]

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

[Αndré]

So your current request is to sort also the album manager by title, right?

[burlington]

Yes please.

[Αndré]

Open albmgr.php, find

Code Select Expand

ORDER BY pos ASC
and replace with

Code Select Expand

ORDER BY title ASC
(twice).

[burlington]

Works perfectly.

Very many thanks

Martin

[Αndré]

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.