Hey guys,
I'm new here and I hope its OK if I tap a lil into your knowledge
base.

I have a table

ID|Name|Job


the ID is an int that auto increases and should stay the same for
history record.
Now I want to put order to the table.
Not by ID, not by name, not by job.
so I want to add a order collumn, but I'm not sure what values it
should have.
I want to list the names and decide to move them up or down in order.
e.g.

ID:1-Steve-Farmer (move up in order button)(move down in order button)
ID:2-Jim-Hunter (move up in order button)(move down in order
button)
ID:3-Al-Baker (move up in order button)(move down in order
button)

then if i click the (move up in order button) from Jim the list would
look like this

ID:2-Jim-Hunter (move up in order button)(move down in order
button)
ID:1-Steve-Farmer (move up in order button)(move down in order button)
ID:3-Al-Baker (move up in order button)(move down in order
button)

i hope you get the gist of what I want.
so what values should i use and how should they change to get the
effect I want? the list will probably be huge and its not really about
jobs and names but i just used this as an example.
Thanks for any ideas
Mawk