1: 
2: 
3:

SELECT UserID, SUM(punkte) FROM Tabelle
GROUP BY UserID
ORDER BY punkte DESC

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10:

$query = "SELECT userid, SUM(punkte) FROM blabla GROUP BY userid ORDER BY punkte DESC";
  $result = mysql_query($query);
  
  while ($dat = mysql_fetch_array($result))
  {
  	  	
  	echo $dat["userid"];
  	echo $dat["punkte"];
  	
  	}

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10:

$query = "SELECT userid, SUM(punkte) FROM blabla GROUP BY userid ORDER BY punkte DESC";
  $result = mysql_query($query);
  
  while ($dat = mysql_fetch_array($result))
  {
  	  	
  	echo $dat["userid"];
  	echo $dat["SUM(punkte)"];
  	
  	}

1:

$query = "SELECT userid, SUM(punkte) AS summe FROM blabla GROUP BY userid ORDER BY summe DESC";