how to sorting and order data?

[peppino]

I would like to be able to reorder data by clicking on buttons to move the item up or down in the list.

The php output of the data will look like this

Field Name (move down button)
Field Email (move up button) (move down button)
Field Address (move up button) (move down button)
Field Phone (move up button)

What i want to do:
i want to move Field Phone up so it is displayed before Field Address when a user click on the (move up button). I want this functionality for all fields displayed.

How do i go about doing this?

Help is MUCH appreciated!

[laserlight]

Maintain a field dedicated to keeping track of the display order. One way is to have it as a linked list of primary keys (but you have to take care to trigger a deletion in the list when you delete a row).

[peppino]

yeah i assume i would need an extra field for keeping track of the order, but what would the logic behind the code that actually moves the item up or down