mysql leaderboard help

[MDanz]

i did this but then realised it won't total the `rating` for a DISTINCT username.  How can i change it so that it totals the rating for a username?

 

	$getuser = mysql_query("SELECT DISTINCT username, rating FROM block WHERE category='$category' ORDER BY `rating` DESC",$this->connect);

				while ($row = mysql_fetch_assoc($getuser)){
				$theuser = ucfirst($row['username']);
				$rating = $row['rating'];

				echo "<div class='leaderboard'><ul><li><a href='profile.php?user=$theuser'>$theuser</a></li><li>$rating</li></ul></div>";

				}

[The Little Guy]

Try this:

 

SELECT username, sum(rating) as rating FROM block WHERE category='$category' group by username ORDER BY `rating` DESC