View Full Version : Summing row data into a simple table

01-25-2008, 09:27 AM
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");

$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:
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,


sir pannels
01-25-2008, 11:48 AM
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

01-25-2008, 12:48 PM
$query = "select `mname`, sum(points) as `points` from `ibf_referals` group by `mname` order by sum(points) desc";

01-25-2008, 11:41 PM
It worked. Thanks you guys, without you this referral system I have would have been useless!

sir pannels
02-01-2008, 01:51 PM
anytime :)