Calculate average of column from MYSQL query

Question

I've got a table that I am trying to calculate the average of the values in a column. Here is my lookup:

SELECT SUM(P1_Score) AS value_sum FROM tblMatches Where P1_ID LIKE $playerID 

Any idea how I can determine the average (sum of values / total rows)?

Answer 1

You can use AVG like so:

SELECT AVG(P1_Score) 

Answer 2

So in your case:

$gameswon = mysql_query("SELECT AVG(P1_Score) AS value_sum                           FROM tblMatches                           WHERE P1_ID LIKE '".$playerid."'");