Summing row data into a simple table

Hey guys,

I'm trying to bring together simple SQL data into a .php table but I'm having difficulties. Was wondering where I'm going wrong?

(Trying to grab mname and points from the SQL data, as shown below)
Photo of the SQL table:
http://img151.imageshack.us/img151/455/helphelplk2.jpg

Php code:
<title>Referral Points - xxx</title>
<?
// connect to database
$con = mysql_connect("localhost","xxx","xxx");
$db = mysql_select_db("xxx");
?>

<?php
$query = "SELECT * FROM ibf_referals";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
$user = $row['mname']. " - ". $row['points'];
echo $user;
echo "<br />";
}
?>

I want to try get it so it shows a leader board of the referral points in ascending order but I'm having a rough time. It keeps giving me the same end product of:
http://img210.imageshack.us/img210/1906/helphelp2sy2.jpg


What I want is to add the points to the associated user in an ascending leaderboard fashion.. Like so:
Example:
Jai - 11
An1mal - 9
bdc64 - 7
User with 1 referral - 1

I apologize for being such a PHP noob.. But can somebody help me with this code snippet?

Thanks in advance,

Denominator

hi there,

Just use the ORDER BY mysql function. Search mysql.com for help on it or change you rquery to the below:


SELECT * FROM ibf_referals ORDER BY points DESC


Cheers, best of luck

$query = "select `mname`, sum(points) as `points` from `ibf_referals` group by `mname` order by sum(points) desc";

It worked. Thanks you guys, without you this referral system I have would have been useless!

anytime :)