Like all good problems, this one is sporadic and seemingly senseless, but I figured maybe somebody here would have some suggestions on possible causes of the situation to be laid out. For our app, we ...

I'm trying to re-order a bunch of rows based upon user preference. For example I have 10 row. There is a column called order_id that gives each row an id from 1-10. I want to be able to do things like ...