Catagory order

[Guest janpugs]

Is there a way for me to resort the catagory order? I just added another Catagory and it is at the bottom, I would like it to be the second one listed . how do I do that without deleting all the catagories and and starting over.

[Guest peppy]

there is a mod for that at cubecart.org :)

[Guest vrakas]

If you need them Alphabeticaly then:

Go to includes/boxes/categories.inc.php

Change the line:

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

to

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

If not then do as peppy suggested :)

[Guest thomasvr]

If you need them Alphabeticaly then:

Go to includes/boxes/categories.inc.php

Change the line:

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

to

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

If not then do as peppy suggested

BEAUTIFUL. Thank you! :innocent:

[Guest That Graphics Guy]

If you need them Alphabeticaly then:

Go to includes/boxes/categories.inc.php

Change the line:

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

to

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

If not then do as peppy suggested

BEAUTIFUL. Thank you!

Indeed.. I was looking for this too. Thanks

~ Dave

[Guest Tammy Hargreaves]

If you need them Alphabeticaly then:

Go to includes/boxes/categories.inc.php

Change the line:

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

to

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

If not then do as peppy suggested

Hi,

Im looking to do this aswell, but i dont know how to get to

Go to includes/boxes/categories.inc.php

Im new to all this

Thanks Alot Tam

www.replicabagsuk.com

[Guest]

You can also do this;

Make category images and name than in a specific order, like "1-category.gif, 2-category.gif,....."

Then add the specific image to each category.

Now open the categories.inc.php file, look for

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

And replace with;

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

So, basically your ordering your categories by renaming your unique category image files. Sounds crazy, but it work on our www.thetreasurebasket.com site perfectly.

:sourcerer:

[Guest Klutzys]

If you need them Alphabeticaly then:

Go to includes/boxes/categories.inc.php

Change the line:

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

to

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

If not then do as peppy suggested

I did this and it is NOT working, see below. I don't see any errors. Please advise!!

Tammy

}

// 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");