Changing order of rows in a database
Hi
Does anyone know a way of changing the order of rows in a database?
e.g.
item order item
1 item1
2 item2
3 item3
4 item4
5 item5
and I want to change the order so if you click a down arrow on item2 it changes the order of item2 to item order 3 and item3 to item order 4 etc.
Thanks in advance