[Solved]: Categories in alpabetical order on index.php

[holdika]

Is there a way to set the directories on the main site so it will display it in Alphabet order, instead of manually adding them? I do have a lot of od dir and I am going to have a lot more.

[Casper]

Do you mean categories, or albums.

If albums, see this thread, http://coppermine-gallery.com/forum/index.php?topic=29
If categories, you will have to do it in the category manager.

[holdika]

It's the Categories. I was hoping may be there is a solution for that to be done automaticly. Because sorting it in the category manager takes a long time, especially when there is so many categories

[Nibbler]

You can do this with a simple code change. In index.php, locate

Code Select Expand


$result = db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent'  ORDER BY pos");


and change it to:

Code Select Expand


$result = db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent'  ORDER BY name ASC");


[holdika]

Thanks I will give it a try

[holdika]

Great! It worked!
Thanks so much!~ :wink: