I have made a site for creating delivery sheets. This works well, but currently they are ordered by postcode, which is far from ideal.
The operator should be able to reorder the list. We are thinking about perhaps giving a priority number to each customer (e.g. priority field in the customers table). However, this presents the problem of how to reorder the list automatically.
Of course, if you take a list like this:
1 Joe Bloggs
2 Fred Smith
3 John Doe
And you decide that you want to add a new customer, who should become number 2, you have to push Fred Smith and John Doe down a place.
How can I get the site to do this automatically? Maybe a system with a table and up/down buttons, like this:
1 Joe Bloggs (up) (down)
Can anyone suggest how to do this, or maybe point me in the direction of a tutorial on the subject?
Thanks in advance for any help offered - it is greatly appreciated!
