...

View Full Version : Summing row data into a simple table



denominator
01-25-2008, 08: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:
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

sir pannels
01-25-2008, 10: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

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

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

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum