Dividing Colums

admin

Administrator
Staff member
Hi, i am having a problem dividing some fields. What i want to do is divide all values in the following colums

Rating / TotalRate

Then this gives me the Rate or Score of each item, i then want to display the top 3.

The sql for the top three is

$sql=\"SELECT * FROM Photos ORDER BY ??? DESC LIMIT 0,3\";

But i dont know how to replace the ??? with the Rating / TotalRate

thanks for any help
Dashe
 
Back
Top