Catagory Order Problem

[Guest poongamer]

For some reason when I add new top level catagories they are listing out of the order Im adding them...

For some reason the first 2 go ok but then any others I add show up on the top of the others on my store home page...any ideas why? can it be the skin I purchased?

[Guest vrakas]

Search for order categories ;)

[Guest mrdave]

To sort categories into alpha order rather than the default cat id order..

open up..

includes/boxes/categories.inc.php and find

(approx line 35)

// query database

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

repalce it with 

// query database

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

save and upload.

job done..

[Guest]

Thanks Captain Bags for the heads up and added here as suggested :blink:

[Guest freifer]

Thanks Captain Bags for the heads up and added here as suggested

Thanks it worked for me

[Guest]

thanks!!

:P