how do i multiply numbers in the same column in order to get an average rating, for a rating system in PHP and MYSqL
AVG()
Please check http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html#function_avg