Results 1 to 7 of 7
Dec 10, 2008, 16:24 #1
Thoughts on reording part of a table...
I keep track of the order in a table with field called 'the_order' and it has integers that increment as you add content. However, when I need to reorder a record using a custom CMS I end up moving 'the_order' number to whatever position and UPDATE all items below that up one.
Is there a better solution than this? If you end up having 1,000's of records you can tie up the table. I wondered if anyone had a quicker method.