Second level members category alphabetically

[attroll]

I am trying to create another category as a second level category and make that members category. I was able to do this buy making the Category Layout as a Members Category in the category I created.

The problem I am having is that I want to have the Default Sort Order as alphabetical but that option is not available to choose from in the Default Sort Order.

Is there a way to get this to display alphabetically?

[Chuck S]

What do you mean the sort box does not have alphabetical?

I see it in there

[attroll]

What I mean is if I go into Edit Categories and click on a category that I created and click on the drop down for the sort order I do not get the option for Aphebeitcal Order like I do in the Members Category.

[attroll]

What I mean is if I go into Edit Categories and click on a category that I created and click on the drop down for the sort order I do not get the option for Alphabetical Order like I do in the Members Category.

I want to create a top level category with a second level under it as a members category and have it display the members in alphabetical order just like in the Members category that is set up when you do the initial installation of the software. Let me show the structure:

Members Galleries (members category)
Hiking Trails
--Appalachian Trail (members category)
--Florida Trail (members category)
and so on.

Basically I want is each category under the Hiking Trails category to be a members category and to have all that members photos that they uploaded to that category to be placed under their name in the list just like the default members category.

As I see it now it looks like you can do this by selecting the category layout option and making it "Member Gallery" and it looks like it displays that way but the only options I have for order is Latest, Most Viewed, Most Active, Most Popular, Random, Least Polular, Image Name, and Title. Alphabetical is not one of the choices.

[Chuck S]

Have you tried adding a new sort in the sort table?

Thats what you need to do. Whatever sort you add is the one it will follow

[attroll]

Originally Posted by Chuck S

Have you tried adding a new sort in the sort table?

Thats what you need to do. Whatever sort you add is the one it will follow

No I have not tried that. I did not know I could do that. Can that be done easily? Are thre docs some place for that?

[Chuck S]

You would just add a new sort in the sorts table like so

INSERT INTO `pp_sort` VALUES (8, 'Alphabetical', 'ORDER BY disporder,title');

[attroll]

Originally Posted by Chuck S

You would just add a new sort in the sorts table like so

INSERT INTO `pp_sort` VALUES (8, 'Alphabetical', 'ORDER BY disporder,title');

Chuck, I don't want to screw anything up because I hate to messing with my database tables so correct me if I am wrong.

I can just run this query in the VB database right?

Content visible to verified customers only.

[Chuck S]

If your photopost tables are in your vb database sure

[attroll]

When I try to insert that and run it as a query in phpMyAdmin it tell me this

Content visible to verified customers only.

I might have ran it twice by mistake. So I went to see if this got added to my Default Sort Order List and these are what display so as you can see it did not get added.

Latest
Most Views
Most Active
Most Popular
Random
Least Popular
Image Name
Title

[Chuck S]

The one I gave you is in the latest as title

[attroll]

Oh I see. I was expecting to see Alphabetical. Thanks.