move up or down records

[s_mujtaba]

Hi...
How to move up or down records in database
by press a button or hyperlink
like this:
id | menu
1 | menu1
2 | menu2
3 | menu3

when i press move up to menu3, it will be:
id | menu
1 | menu1
3 | menu3
2 | menu2

Bye...

[laserlight]

Aside from the id, maintain another column whose values will be used to sort the items for display. To "move up" an item, swap its sort value with the item just before it.

[rsmith]

I'm trying to do something simliar... laserlight, if I'm understanding you correctly I would setup a db like this:

id |  item_name  |  sort_by
----------------------------------

and when I use the hyperlink to call my function moveup() it would swap the sort_by of say id 2, with id 4? If that is correct then can you provide an example of what would be a good text input to use for the sort_by? If I am wrong, please advise.

TIA