In the Category Management control panel there are arrows that permit you to create a custom sort order. How do you access this sort order using a SQL ORDER BY statement in a template?
Thanks,
Brian
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
December 03, 2010 12:22pm
Subscribe [3]#1 / Dec 03, 2010 12:22pm
In the Category Management control panel there are arrows that permit you to create a custom sort order. How do you access this sort order using a SQL ORDER BY statement in a template?
Thanks,
Brian
#2 / Dec 04, 2010 2:25pm
Hi Brian,
This sort order is in the exp_categories.cat_order column. You can use the Query Module to directly query this data.
Cheers
Greg
#3 / Dec 06, 2010 10:26am
That worked just fine. Might be a good thing to add to the user guide.
Thanks!
#4 / Dec 06, 2010 5:12pm
Thank your for the feedback, Brian. Glad to see you’re up and running. Post again as needed, please.