[SOLVED] descending order of rating

[jck]

suppose in a table there are ratesum and ratecount and rating is ratesum/ratecount how do i sort them in descending order of rating

[cooldude832]

<?php
$q = "SELECT * FROM Table ORDER BY sum(ratesum/ratecount)";
?>

[jck]

what is  sum(ratesum/ratecount)

[teng84]

$q = "SELECT ratesum, ratecount FROM Table ORDER BY rating";

 

is that what you mean?

[jck]

there is no field for rating in the table ecause it is not storing decimals so on the pages its dynamically calculated so i need to order by ratesum divided by ratecount

[jck]

stored as float

[trq]

SELECT ratesum/ratecount AS rating FROM Table ORDER BY rating;