Posted on

Weekend challenge: keeping ordered lists

Yep, here’s another weekend challenge. It’s not a regular thing, I just post one when I think of something and there’s no prizes except eternal glory!

This time, try and come up with a nice clean and efficient way of maintaining ordered lists. That is, all items in a table, or groups of items, should be ordered *inside* that table/group relative to eachother, and it should be possible to move them around (i.e., change that order and insert new or existing items at any point) without too much hassle. That last requirement is probably the main thing you will want to think about…

Naturally, you shouldn’t muck around with the auto-inc ID, you know how I feel about that 😉

Good luck, and have a nice weekend!

Posted on