Best Method? Ranking 25 Teams

Svoboda

I'm attempting to create a Top 25 ranking system and I was wondering what the gurus here would recommend in terms of having the end user input their rankings.

Right now I have a table with all of the teams, so I figured I probably could have 25 select boxes that are populated from my database. Being pretty green when it comes to PHP, would this be the route you'd recommend I take?

Then, how do I validate them so the end user doesn't select the same team twice? Is there a way to update each select on the fly as the user selects a team? If not, how would you recommend I handle this?

dagon

i use this: http://tool-man.org/examples/sorting.html to do something jsut like that, there are a number of versions of that sort of thing some with ajax some just with js

Wales

Not a guru but...
I'm guessing.. having a form of the 25 teams...when a user selects one it posts the team name and the selecters ip address to the database.
The ip is there so it'll stop the same ip from selecting more than once.
Then count the rows where a variable equals to the team name ordered by desc.

Something along those lines.

Roger_Ramjet

Neat tool and link dagon.

Probably the most user friendly and stylish way to go Svoboda.

Svoboda

Not sure if that would work. There are 120 teams to choose from when ranking, so it would probably be a logisitical nightmare on the screen not to mention wierd to look at.

Weedpacket

Have some mechanism to pick 25 from 120; as each is selected, it is moved to a list. Sort the list.

Roger_Ramjet

There is an example of 2 dimensional sorting on dagon's link as well.You should be able to get 4 columns of 30 on a page, unless the names are really long in which case abbreviate them.

Any method you use will be more awkward and cumbersome than that neat tool so why waste time reinventing the wheel when it cannot produce a more apt or stylish solution.

Weedpacket

There's a link on that page to moving items between lists. Use the big list (rearranged as Roger Ramjet suggests) as a place to get the 25 from, moving them to the other list and then, if need be, shuffling them around to get the order just right.