A big part of it will be to figure out how you want people to rate the songs: 1) Rate each song on a scale of 1 to 10 or the like; default to no vote 2) Enter a list ranking for each song, for example 1 for their favorite, 2 for their 2nd favorite etc.
Probably the first would be easier to handle for the person voting, that way they don't have to scroll around figuring out whether they like song number 10 better than song number 30 for example. Also they don't have to vote for each song, you just tabulate the average rating per vote so it's scaled correctly, and those songs not getting votes won't be penalized. -- Josh ----- Original Message ----- From: "Greg Morphis" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, August 01, 2006 1:51 PM Subject: Re: Hey, does anyone have any ideas regarding a "top 40" voting system? > 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.. ://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=19154.14955.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
