Category Ordering

[Guest Scorpion]

Is there any way I can get my categorys to be orded by cat_id rather than alphabetically

Thanks in Advance

Phil

[roban]

open includes/boxes/categories.inc.php

** First make a back-up of the origianal file. **

About line 35 Find:

// query database

$results = $db->select("SELECT cat_name, cat_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = 0");

$resultsForeign = $db->select("SELECT cat_master_id as cat_id, cat_name FROM ".$glob['dbprefix']."CubeCart_cats_lang WHERE cat_lang = '".$lang_folder."'");

Change to:

// query database

$results = $db->select("SELECT cat_name, cat_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = 0");

$resultsForeign = $db->select("SELECT cat_master_id as cat_id, cat_name FROM ".$glob['dbprefix']."CubeCart_cats_lang WHERE cat_lang = '".$lang_folder."'order by cat_id");

[Guest Scorpion]

That doesnt becasue it doesnt order them how i want but thanks for the mod it may come in handy some other time