Sortable lists using PHP

[eluser]rogierb[/eluser]
well, one not so beautiful approach

Add a field to your tabel called 'order' to define the order.
Create a form for each up/down arrow. In this form, create 3 hidden fields
1: record_id
2: order + or -
3: upper/lower record_id depending on up/down arrow


On submit, update your record id with the new order,
Then update the other records (upper or lower) with their new order.

It is far more easy to do by javascript thought