[SOLVED] MySQL SUM() problem

[Andy17]

Things you need to know

 

I have a table called "points" where I want to select a given user's rows. Each row has a number in the column "points" and I want to add all these numbers and get the total amount. So, here is a simple example:

 

id       |       username        |      points
---------|-----------------------|------------
0        |       test1           |      25
1        |       test2           |      10
2        |       test1           |      15
3        |       test1           |      50

 

In the example above, I would want to choose the rows where the username is "test1" (0, 2, 3) and add the points (25 + 15 + 50 = 90). This is the code I have so far:

 

<?php

$username = $_SESSION['username'];
$findpts = "SELECT points, SUM(points) FROM points WHERE username = '$username' GROUP BY points";
$findptsresult = mysql_query($findpts) or die(mysql_error());

if ($findptsresult)

{

          // Unfortunately, the following only adds two numbers and totally leaves out any more numbers after that
          $row = mysql_fetch_array($findptsresult);
          echo $row['SUM(points)'];

}

?>

 

I was thinking of going something like this, but I am missing a big part of code.

 

<?php

// First code = same as above

while($row = mysql_fetch_array($findptsresult))

{

// Some code here 

}

?>

 

I might be getting at this from a completely wrong angle, I'm not sure. Any ideas on how to do this?

 

Thank you!

[F1Fan]

You are trying to sum the points column AND return the points column separately. That's your problem.

[PFMaBiSmAd]

You need to -

 

GROUP BY username 

Grouping by points will result in groups of rows where the point value is the same.

[Andy17]

You need to -

 

GROUP BY username 

Grouping by points will result in groups of rows where the point value is the same.

 

That fixed it, thanks a lot!