Making a SORTABLE Product Catalog

I want to make it so the admininstrator can change the display order

[Parlays]

Hello everyone,

I'm creating an online store with a bunch of products that are in seperate categories.

In the database I have a column for 'display_order' and I want to make that number editable for the admininstrator to change the product display order.

Does anyone know if there is a good method for managing the display order in the database. There have been challenges for me, that's for sure. Any advice is much appreciated.

[eelixduppy]

You could have a column with integers in it. Have '1' be at the top of the list, and 'n' (where n is a number) be at the end of the list. Then when you call the info from the database, you would just have to ORDER BY that column.

As far as editing the display order numbers, you can do it manually through phpmyadmin or the console, or through a web browser if you are up to coding your own little interface. :)