Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › Product Categories in Alphabetical Order

Product Categories in Alphabetical Order

Thread began 6/23/2009 3:34 pm by jasonkline326722 | Last modified 6/24/2009 2:14 pm by jasonkline326722 | 1901 views | 2 replies |

6/23/2009 3:34 pm | #1 jasonkline326722

Product Categories in Alphabetical Order

How can I get the product categories in PowerStore to show in alphabetical order?

6/24/2009 7:52 am | #2 Ray BorduinWebAssist

Add an ORDER BY statement to the SQL that controls that list. It should be on the menu include file for the menu you want to update.

Did this help? Tips are appreciated...

6/24/2009 2:14 pm | #3 jasonkline326722

This seems to have done the trick.

$query_menuwriter_productcategories = "SELECT CategoryName, CategoryID FROM productcategories ORDER BY CategoryName";

menu.php

Thanks you.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.