order of catagories in side nav

Dear WA,

My client wants to control the order of their categories as well their products. I understood the order to be set ascending or descending alphabetically. Check this link:
contactus.php
What is controlling the Coats Leashes Collars order? Is it the order in which I entered the catagories?

Thanks,

Lisa

Yes, by default, the recordset will use the primary key column if there is no ORDER BY statement, so the categories will display in the order you enter them.

Is there any (hopefully, easy) way to reorder the categories list that is displayed? I know if I delete a category name and re-add it (in hopes that it would show up at the end of the list), I loose all the entries associated with that category, which is not what I want.

Any advice would be greatly appreciated.

The recordset is on the CSSMenuWriter/intermediate.php page:
SELECT * FROM productcategories WHERE CategoryID = (SELECT ProductCategoryID FROM products WHERE ProductCategoryID = CategoryID AND ProductLive <> 0 LIMIT 1)

you just need to add an order by clause:
SELECT * FROM productcategories WHERE CategoryID = (SELECT ProductCategoryID FROM products WHERE ProductCategoryID = CategoryID AND ProductLive <> 0 LIMIT 1) ORDER BY CategoryName