Order category list like the products

[RomuGb]

Hi,

 

I'd like to order the category list like the product list with a combo in the page at this url

=> www.mywebsite.com/index.php?id_category=14&controller=category

Or in the following template page : category.tpl

 

By name (a to z et z to a), by position (position defined in the back office).

 

I try to find the query which extract and order the categories in :

 

/httpdocs/controllers/front/CategoryController.php or in the template page (category.tpl),i find only the foreach but no ORDER BY.

 

Do you know where this code is and maybe you could explain me how to create a combo on the template page to define the ORDER BY parameters in the query

 

Thanks for your precious help.

 

Romuald.