Hi Folks,

I have a database that, among other things, has a field called 'pos' -
short for position. The idea is that via a form, I can change the
position any given result is output. For example, if record 1 is given
the pos 3, and record 3 is given the pos 1, then record 3 will be
displayed first (records output using the 'ORDER BY pos' query).

Now, where I'm having trouble here is how I can, via a form, change the
position numbers. If I change multiple positions at once, then click
the submit button, it will create a list of the new values - however
theres nothing in with that for me to say where those values need to be
updating.

I know I could do them individually quite easily, but that could take a
while to do - ideally I want to stick all the numbers on the same form
and have the positions changed in one go.

Alternatively, a system of icons along the lines of 'move up' or 'move
down' would be excellent, but I have no idea where to start with that one.

Thanks for anyone that managed to understand that!

LB