Sum in every individual

[Yohanne]

Hi coders,

 

 

do you think it is possible to get the sum of every Individual like below? 

 

[kicken]

Yes. How depends on where your data comes from. If you're using Mysql and have a query to return the data, just add in a GROUP BY clause and SUM() function.

 

Otherwise group the data into an array in PHP with a total variable for each group.

[priyankagound]

You need to add a GROUP BY clause to get the sum() for each player:

eg:

SELECT Player.PlayerName, SUM(COALESCE(Exp.ExpChange, 0)) AS exp
FROM Player
LEFT JOIN Exp
ON Player.PlayerID=Exp.PlayerID
GROUP BY Player.PlayerName
ORDER BY exp;

[Barand]

TIP: Avoid column names such as "desc".

 

DESC is a reserved word in SQL