Guest bassyard Posted June 27, 2005 Share Posted June 27, 2005 Hi there, How do I get the latest product on the top of the category page, now they always go last... Did I overlook something? :) Quote Link to comment Share on other sites More sharing options...
Guest bassyard Posted July 4, 2005 Share Posted July 4, 2005 Anyone? :) Quote Link to comment Share on other sites More sharing options...
Guest estelle Posted July 6, 2005 Share Posted July 6, 2005 Hi bassyard, Edit includes/content/viewCat.inc.php. Add the text in bold below: $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 ".$glob['dbprefix']."CubeCart_inventory.productID DESC"; Enjoy!! :( 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.