Jump to content


This topic is now archived and is closed to further replies.


Sort output

Recommended Posts

In my script as seen below in the admin area I can add whatever categories I wish to add problem is when you add a category it goes to the bottom of the list and the only way to put them into alpha order is to number the sort section to move them.

[img src=\"http://www.abidders.com/images/catadd.gif\" border=\"0\" alt=\"IPB Image\" /]

These categories are stored in a db.

And ouput is generated as show below exactly in the sort order specified in the add category section.

[img src=\"http://www.abidders.com/images/catsort.gif\" border=\"0\" alt=\"IPB Image\" /]

Is there an easy way that categories could just be added and the output will automatically generate in alpha order from a to z

Share this post

Link to post
Share on other sites
You can do this with the query

SELECT * FROM tblCategory ORDER BY [Fieldname]


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.