krystal35 Posted October 18, 2006 Share Posted October 18, 2006 Can someone please tell me what i do for my categories to be alphabetcial with the homepage on top, then specials next and then the rest of categories. Thanks Quote Link to comment Share on other sites More sharing options...
roban Posted October 18, 2006 Share Posted October 18, 2006 This will make them alphabetical open includes/boxes/categories.inc.php About line 35 // 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."'"); REPLACE 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"); $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_name"); Save, Close, Upload file Quote Link to comment Share on other sites More sharing options...
krystal35 Posted October 21, 2006 Author Share Posted October 21, 2006 Thanks for that Roban, so wondering now if you can help me with putting specials underneath homepage. It's in the list down the bottom. I did see a forum entry a little while ago and now I can't find. And I have looked all over. Thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted October 21, 2006 Share Posted October 21, 2006 I just put * around it - made my category *In Stock Specials* and it puts it right under the homepage link */* Quote Link to comment Share on other sites More sharing options...
krystal35 Posted October 21, 2006 Author Share Posted October 21, 2006 thanks Mysty that worked. Krystal Quote Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2006 Share Posted October 22, 2006 No problem. Also makes the category stand out nicely I think Sometimes the easiest solutions are the best :) 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.