Help with SELECT command

[mcmuney]

I've been using this line of code for quite some time, but just recently it stopped working:

 

SELECT * FROM sc_rate_avg WHERE type='$rt' ORDER BY (round((sum_/count_),2)) DESC,count_ DESC LIMIT 1

 

I've identified that it's no longer working because of this portion of the code: "(round((sum_/count_),2))"

 

Is there another way of achieving the same results?

[mrdamien]

Well i dont know what sum_ or count_ are in your context, but sum/count mathematically, is an average.

 

SELECT *, AVG(column) FROM sc_rate_avg WHERE type='$rt' ORDER BY AVG(column) DESC LIMIT 1

[mcmuney]

Well, I don't think I can use AVG(column) because I have a single row per id and sum_ = score and count_ = how many times, so the true average can be calculated by taking sum_/count_

[mrdamien]

Oh I see.

 

Could you post the error message?  There doesn't seem to be anything wrong with the query structure.

[mcmuney]

There's no error, but it doesn't produce any results. When I remove the "round" portion of the code, the query shows results.

[psychowolvesbane]

I'm not too sure but do you need to have the brackets around the whole "Order By (round((sum_/count_),2))" part? When you just have no brackets with normal ORDER BY fields scripts. 

[mcmuney]

Tried nearly everything that I could think of, it just doesn't seem to be doing the math "A/B".