I'm trying to create functionality like that offerred by the Netflix movie queue.
Users will be looking at a list of items, and should have access to a field in a given row that allows them to reorder the list.
For instance, if the table is:
And the user enters a 1 in the 1st box in the 3rd row, the table will now be
I am using PHP for the middleware. The answer should allow for more than a single re-ordering, where users can change multiple values at a time. Again, above example, but the user enters 2 next to purple and 1 next to green:
The answer should account for this, in addition to best practice for setting up the table and error checking (i. e. user enters a "1" for both green and purple). It will also need to account for new entries being added with a proper order number to the end of the list.
Thanks in advance, and I'm going to cross-post to the PHP section...