Guest bikedevil1983 Posted April 14, 2007 Share Posted April 14, 2007 Hi guys, I am trying 2 order the category's bij alphabet. I've read all the posts about it, and tryed a lot, but everything you guys posted, is already in the standard script! :-S i'm using version: 3.0.15 and have the killer skin. a'm i that stupid? or is there something very wrong? every help is apreciated! Quote Link to comment Share on other sites More sharing options...
Guest Posted April 14, 2007 Share Posted April 14, 2007 Its only a small change - in the posted solutions look at the ORDER by towards the end - thats what changes. Quote Link to comment Share on other sites More sharing options...
roban Posted April 14, 2007 Share Posted April 14, 2007 Open /includes/contents/viewCat.inc.php Find somewhere @ line 158 $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE ".$glob['dbprefix']."CubeCart_cats_idx.cat_id = ".$db->mySQLSafe($_GET['catId']); Replace it with $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE ".$glob['dbprefix']."CubeCart_cats_idx.cat_id = ".$db->mySQLSafe($_GET['catId'])." ORDER BY name ASC"; Quote Link to comment Share on other sites More sharing options...
Guest bikedevil1983 Posted April 15, 2007 Share Posted April 15, 2007 Already got it guys, thanks a lot again! Kind regards, Bikedevil1983 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.