paulman888888 Posted October 20, 2008 Share Posted October 20, 2008 I have my Table but i would like to add a extra coloum for rating. Am not fused how it works but i cant think how to make it. If someone rates it 10 shall i add 10 to the score? Not very good because i cant have x/10 Do i add 2 extra coloums 1 have the rating and 1 how many votes. I dont no the math to work everything out! Am stuck and would like any ideas, i can add as many coloums need but i dont want to make a new table. Thankyou Paul Quote Link to comment Share on other sites More sharing options...
Orio Posted October 20, 2008 Share Posted October 20, 2008 The simplest solution I can think of is adding two columns, one for the total count of votes (10+9+4+10+...) and one for the number of votes (1+1+1+1+....). Then you display the average. Orio. Quote Link to comment Share on other sites More sharing options...
paulman888888 Posted October 21, 2008 Author Share Posted October 21, 2008 I no this is probly turning into a maths question but how would i do the math. I think something like this; votes divided by number of votes times by 100. Would that get rating out of a 100? Thankyou Paul Quote Link to comment Share on other sites More sharing options...
Orio Posted October 21, 2008 Share Posted October 21, 2008 If users vote between 1 to 10, so SUM/NUM_VOTES would give the average (a number between 1 to 10). If you multiply it by 10 the rating would be between 10 to 100. But I think it's best if you use the same scale on both- people can vote between 1 to 10 and will see a rating between 1 to 10. Orio. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.