Currently the ratings are calculated by default as (Sum Of Votes)/(Number Of Votes). However I need to implement weighted average rating based upon an additional input value to be captured while the users votes (i.e. in vote.php). I understand how to add fields to the links table but I need a field attached to each of the votes polled (i.e. in the ratings table). Is there any way in which I can add a field to the ratings table and use it in the votes.php file to modify the formula to calculating the rating. Can I add another field in the ratings table (through mysql) and use its name in the votes.php form to get the value automatically populated? Would this value be available in the templates? Thanks in anticipation.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on ratings calculation
Rupin
Usergroup: Member
Joined: Feb 13, 2006
Total Topics: 1
Total Comments: 1
Currently the ratings are calculated by default as (Sum Of Votes)/(Number Of Votes). However I need to implement weighted average rating based upon an additional input value to be captured while the users votes (i.e. in vote.php). I understand how to add fields to the links table but I need a field attached to each of the votes polled (i.e. in the ratings table). Is there any way in which I can add a field to the ratings table and use it in the votes.php file to modify the formula to calculating the rating. Can I add another field in the ratings table (through mysql) and use its name in the votes.php form to get the value automatically populated? Would this value be available in the templates? Thanks in anticipation.