forum.coppermine-gallery.net

No Support => Feature requests => Topic started by: holdika on April 03, 2004, 09:57:24 pm

Title: [Solved]: Categories in alpabetical order on index.php
Post by: holdika on April 03, 2004, 09:57:24 pm
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.
Title: [Solved]: Categories in alpabetical order on index.php
Post by: Casper on April 04, 2004, 12:04:41 pm
Do you mean categories, or albums.

If albums, see this thread, http://forum.coppermine-gallery.net/index.php?topic=29
If categories, you will have to do it in the category manager.
Title: [Solved]: Categories in alpabetical order on index.php
Post by: holdika on April 04, 2004, 03:43:04 pm
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
Title: [Solved]: Categories in alpabetical order on index.php
Post by: Nibbler on April 04, 2004, 06:15:13 pm
You can do this with a simple code change. In index.php, locate

Code: [Select]

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


and change it to:

Code: [Select]

$result = db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent'  ORDER BY name ASC");
Title: [Solved]: Categories in alpabetical order on index.php
Post by: holdika on April 04, 2004, 06:58:26 pm
Thanks I will give it a try
Title: [Solved]: Categories in alpabetical order on index.php
Post by: holdika on April 04, 2004, 07:02:08 pm
Great! It worked!
Thanks so much!~ :wink: