Adding and averaging in Mysql really ...

[havoc]

Ok i have coded myself into a corner heh. I have a php script that reads a bunch of records and it has a rating system.

in the DB it has to fields 1. Score 2. Votes.

In these fields there are total score and how many votes
for eg Score = 80 Votes = 8 . So the rating will be 8.0.

Is there a Mysql query i can use to get the rating from the two fields and display as top rated?

for eg something like

$query = "GET * FROM 'record' WHERE average 'scores', 'vote' DESC";

I thought you can ... but i could be wrong. Thanks in advance.

[hughie]

If I am thinking correctly you need to do something like..

$result=mysql_query("SELECT *,(Score/Votes) AS theaverage FROM record ORDER BY theaverage DESC");
hope it helps.

Hughie

[havoc]

interesting but getting a syntax error . I will keep playing .. thanks for the info

[havoc]

Hrmmm Can anyone geta working query, i have tried for a couple of hours still haven't worked out a solution

[coopster]

The query in hughie's solution should not be causing syntax errors. What exactly is the issue you are having?

[havoc]

Ahh there was a " out of place it works now .. thanks a trillion