Moving a MySQL row up through the stack...
Posted by: Eric Sepich
Date: June 26, 2013 10:24PM
I have a table like this:
I am looking for a way either by way of a MySQL query or through PHP to move an item up through the stack. For instance I may want torder 3 to become 2 and then renumber all the other torders to correspond to three moving to torder 2. The array I am ordering by torder so that my data grid view populates in the right ascending torder.