Swap

[CoB-Himself]

I have a database full of info with each having their own Id.

I am giving the client the ability to order the posts.

I need a way to swap id's in the database. Do I need to make a temporary var and then put it back in?

Is their a swap function?

Thanks... need help ASAP.

[xblue]

swapping integer values of two rows:

UPDATE table SET field=$num1+$num2-field WHERE field IN($num1,$num2)