Changing arrangement of entries script

Squiggles

Hello all,

I'm searching for a way to change the arrangement of entries generated from a mysql script (something like a "move up / move down" routine). Is there a snippet (or a tutorial) that I can use to get this done?

Many thanks in advance. 🙂

brandtj

I can't recommend any tutorials or snippets, but I would suggest just adding an extra column in your table called "order" that would hold a number from 1 to x, x being the number of rows in the table. When you want to move obejct, say, 28, up one in the list, find item 27, set it to 0 (temporarily), then set 28 to 27, then set 27 to 28.

I would recommend doing the switch in three steps like that so that you could make the order column a unique key, then there wouldn't be any problems.

Hope it's helpful!! 😃

Squiggles

brandtj wrote:
I can't recommend any tutorials or snippets, but I would suggest just adding an extra column in your table called "order" that would hold a number from 1 to x, x being the number of rows in the table. When you want to move obejct, say, 28, up one in the list, find item 27, set it to 0 (temporarily), then set 28 to 27, then set 27 to 28.

I would recommend doing the switch in three steps like that so that you could make the order column a unique key, then there wouldn't be any problems.

Hope it's helpful!! 😃

Thanks for the suggestion. But what if a record is deleted? How would this behave, if ever? Would it still work if there are gaps in the arrangement?