Change a whole list of numbers by 1 up or down

Paragon

Ok this is what im trying to do. I want to show certain users in a certain order. I did this fine.

Now what I need to do is make it in the admin panel.

What I want to do is have it like this

username up(check box) down(check box)

Now the user could be any way im not using the ID feild for this im using another int.

Is it possible to change the whole MSQL numbers by 1 up or down depending on that user.

so say this for example

Tim up(check box) down(check box)

gary up(check box) down(check box)

paragon up(check box its clicked I want to move him up were gary is) down(check box)

ect...

How could I do this ?

Thanks for any help or suggestions.

okuto1973

Well....if i have understood........you want to shift two people depending on what you click (up or down checkbox or buttons.....)

If you want to do that without refresh the web page you have to use javascript.......

If you want to refresh the web page (or you prefair to do that!) you can easily change the number between the two (the character chosen and the up or down depending on the action.....) making an update on the db.

drawmack

what I would do is this

set up each user with three radio buttons make the values of the radio buttons -1 0 and 1; label them move up, no move & move down respectively.

write a little javascript that does the following

if you select move down, it marks the next person on the list to move up

if you select move up it marks the previous person on the list to move down.

that will keep conflicts from happening.

Then when you process this with php just add the value of each user's radio button to their order by field.

Paragon

hah, Actualy I didnt want to change it on the page. I wanted to change the information in the database. How can I change 1 value by -1 and the other by +1 just by clicking 1 check box?

Sorry if I was unclear.

okuto1973

Just with a checkbox you cant!
You have to click on a button to perform a submit!
And the page you go have something like that......

$update="update table_name set userdata=userdata+1 where id=idchoosen";

$update="update table_name set userdata=userdata-1 where id=idchoosen";

if you want to add or to decrement the value userdata.

You can do for each user two button with the image "up" and "down"......and check which you have clicked on!
I can't write all the code!
Do something post here and i can add something!