MySQL Multiplication seems slightly weird

[eluser]bapobap[/eluser]
Think I might have figured it out, the column name that stores the rating of a single review (loads of which make up the average) is called rating. It seems MySQL was multiplying one of these by 20, instead of my new average value that I was calling rating.

rating * 20.0 took the rating field of a review and multiplied it by 20 rather than my newly created average. This was even though I was grouping the reviews together and wasn't even including that column anywhere for the result.

So I called it something random, AS total_rating, but ->select('total_rating * 20.0 AS percentage') tells me there is no column called total_rating.

I'm not sure why that's happening, any ideas on that one?!

Thanks again