Calculating a rating by adding number of points and dividing by number of items

Posted on 16th Feb 2014 07:03 pm by admin

I have a site that users can post links to files to download. They can rate these files on a 1-5 scale. I had someone make a Top Rated section for the site, to show the user with the highest rating for their links. However, it just adds a total of points, i.e. if the user has 3 links rated 5/5, their points are 15, if a user has 10 links rated 5/5, their points are 50. It displays the rating based on the number of points, but I would like it to divide the number of points by the number of links. Here is the section of code that deals with the rating calculation, I just don't know enough about syntax to figure out how to divide by the other variable.

Code: (xml) <?xml version="1.0" encoding="utf-8"?>
<sqlmap>
<select id="getTopPoster" resultClass="array">
<![CDATA[
select username, count(linkid) as linkposted from link group by username order by linkposted desc limit 5
]]>
</select>

<select id="getTopRated" resultClass="array">
<![CDATA[
select username, sum(rate) as point from link where rate<>-1 group by username order by point desc limit 5
]]>
</select>
</sqlmap>
I know it is xml code, but I didn't know where else to put it, the rest of the site is built using Prado

Your Answer:

Login to answer

Other forums

Place specific image in html page when specific name is typed.
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

search query in mysql in php problem
my search query wont work, i know, that my codes are correct.please help

Code: [Select]&l

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i