Sub Categories Do Not Save In Order In Overview

As the categories are sorted in a special way (the tree structure), they come sorted by name out of the database but are then processed by the tree routine, where the subcategories are forced to be displayed under their appropriate parent categories.

The only way to avoid this is to declare all categories as main categories without subcategories.

Otherwise a change in the code which organizes the tree structure would be necessary. This code should be replaced by a code which keeps the sort coming from the database and builds a regular select box rather than a tree stucture select box. But this would be a major affair.

You may change all occurances of this code. However, the tree structure will be kept. Within the tree, the categories are sorted alphabetically.

To avoid a tree structure, define all categories as main category - no subcategories.

Hi Jock,

I did not try out yet whether it works, but you could try to change the code the following way:
Old

$query .=\" ORDER BY pid, ordering, cat_name\";

$query .=\" ORDER BY cat_name\";