i tried updating the value on the last item to 998 and the new result was applied.
the result was:
UPDATE `items` SET `ItemOrder` = 998 WHERE `ItemID`=27
it would appear that the loop is not occurring for the multiple updates
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.