Have a main songs table with song info, and a scores table with song IDs and a number say 1-10 score. Query the scores table to get an average, arrange query by that average and either use SQL to get the top 40 rows or through the use of CFLOOP output the 40 top scores..
On 8/1/06, Jeff Small <[EMAIL PROTECTED]> wrote: > I've been asked to help out a friend conceptually, but I'm not sure exactly > how to proceed. He wants to have a "top 40" voting system where they will put > 40 song titles up on a web page, and people will "vote" on them. > > Sounds pretty simple, but I'm not sure about what would be the best way. He > seems to be leaning toward "we'll put them on the site, and people will put > them in the order that they want them in" but that sounds kinda clumsy and > unwieldy. I can't see people having the patience to REALLY do that. What > about the ones near the bottom? Would people just get tired after about 20 of > them and just submit? What would you do about ones that don't get "votes" or > aren't filled in? What order would you present the songs in? Alphabetical > seems the likely choice, but what about all the songs that begin with "W" or > "T" or the ones shoved to the bottom? Would the songs beginning with A > naturally gravitate to the top simply because of the way they're presented to > the user? > > Do you see where I'm coming from? Has anyone ever built a voting tabulation > system to do something like this? > > I was leaning towards a "points system" where maybe people picked their top > ten songs, and they got a point value based on their ranking. 10 points for > first place, 9 for second, etc, and totaling up all the "scores" each song > gets. > > I realize that a TRUE top 40 system is a system that rewards sales, and so > I'm struggling with how to rectify "voting" for something that would normally > be easily to tabulate. > > Any suggestions, both from an interface standpoint, and the pure tabulations > standpoint? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
