One Coloum rating system. Help!

[paulman888888]

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

[Orio]

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.

[paulman888888]

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

[Orio]

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.