Reorder Records

[variantstudios]

I basically would like to know how to reorder a list by changing a ordered field id to modify the order of the results.

For example:
ID: 1
ORDERID: 2 (change to 3)
TESTDESC: Testing 123

ID: 2
ORDERID: 2 (change to 1)
TESTDESC: Testing 456

ID: 3
ORDERID: 3 (change to 2)
TESTDESC: Testing 789

I want to find a way how to do this to make it easy for clients using a CMS. I have seen a few ways how to do this using form list box, DHTML dragging to reorder and also using arrows to move the records up and down.

I just would like maybe some help/advise on a good technique to handle this. Even if someone could list links to examples/tutorials.

I appreciate the help.

[vaaaska]

On the server side you can either use javascript to reorder more than one at a time or use php to do it one at a time (unless you go for some really complicated html form stuff and that's just too much of a pain in my opinion).

Check out a javascript class by Toolman (search on Google). It will allow them to reorder things. Once you have this you can pass the order back to php.

Or, if you just use some drop down boxes you can easily allow folks to change them one at a time. Each time you can make a change it will reorder the list starting with the changed item and go down the list from there (+1, etc).

If you do a search you can probably find a few examples around the forum as well.