title: Reordering an ordered list
body: <p>I have a following SQL table with data</p>
  
  <pre><code>ProductList 
  id  order productname
  79   1     name1
  42   2     name2
  67   3     somename
  88   4     othername
  99   5     XYZ
  66   6     ABC
  </code></pre>
  
  <p>Display order is very volatile, it will change frequently, users will add or remove items and reorder the items.</p>
  
  <p>How should i handle this situation without updating multiple records. Example: if user enters a new product between 1 and 2 order, i do not want to update the order of all the records beneath 2 and if someone switch order 3 to 4 i don't want to update every record under 3.</p>