Summing row data into a simple table - Help!

[denominator]

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:

 

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:

 

 

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

[rajivgonsalves]

this

SELECT * FROM ibf_referals

 

should be

 

SELECT sum(points) as points, mname FROM ibf_referals group by mname;

[denominator]

Wow.. Such a simple fix.. It worked perfectly! Everything is going smoothly in the .php now!

 

It's good to see some polite people on the internet every now and then

[rajivgonsalves]

We'll I see your new to the forum.. Welcome to Phpfreaks.com .. you'll find alot of help here...