reording numbered list

dreams4000

Hey all,

I have a list of names. Each name has an input box next to it for a priority setting (1 through however many are in the list). I want the user to be able to put whatever priority number they want next to the name, click save, then have the list reorder based on that new priority setting.. So for example:

If the list was

1
2
3
4
5
6

Then the user changed 5 to 3... I want 3 to become 4, 4 to be 5, 5 to be 6 etc. This needs to work in the inverse as well, where if the user changes 1 to 6... 6 needs to become 5, 4 to 3, 3 to 2 etc.. Lastly:\ this should also work if multiple numbers are changed.

I have been looking at a few posts that have asked about it on the forums here but there hasn't seemed to be any good answer. If anyone could help out, it would be appreciated. I have tired some different code attempts but nothign seems to come close. Any ideas?

bradgrafelman

Can we see the page? Depending on how you setup the form, you could create an array, and then use an array sorting function to sort numerically...

EDIT: If we can't see the page, can you either post the HTML source as an attachment, or post some of the form HTML so we can see the field names, etc.?

dreams4000

Hey there.. Thanks for the reply. The form is pretty basic. I have a sql call that pulls a list of names. Then I just loop through each of those names to populate a variable in an html input box. The user clicks save, it sends them to a page with the same sql call so it loops the same, then grabs some other vars from the call as well as grabbing their input var. The form and sql and all that works like a charm, I just need to reorder the numbers. A quick not code correct idea is below:

--Sql Call

<form>
-A for loop {

<input box with $var for value>
{

That above sends to another simple page that is:

--same sql call

-Same for loop {

-Sql insert, update or delete depending on if the field exists or not already. Now all rows have been inserted or updated. Since no ordering was done, some rows may have duplicate order numbers. eg. 1,2,3,3,3,4,5,6

And: (this is where I need an update to correct the numbering order)

{

Lastly I simply display the list that was generated above..

The stuff above is pretty basic, but it should give you an idea of what I am doing. If you need more info just let me know. I don't have the exact code on me right now but wanted to get you a response. Thanks again for your help!