Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Jan 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile 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:


    Php code:
    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
    Last edited by denominator; 01-25-2008 at 09:31 AM.

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Posts
    905
    Thanks
    23
    Thanked 5 Times in 5 Posts
    hi there,

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

    Code:
    SELECT * FROM ibf_referals ORDER BY points DESC
    Cheers, best of luck

  • #3
    Senior Coder shyam's Avatar
    Join Date
    Jul 2005
    Posts
    1,563
    Thanks
    2
    Thanked 163 Times in 160 Posts
    PHP Code:
    $query "select `mname`, sum(points) as `points` from `ibf_referals` group by `mname` order by sum(points) desc"
    You never have to change anything you got up in the middle of the night to write. -- Saul Bellow

  • #4
    New to the CF scene
    Join Date
    Jan 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It worked. Thanks you guys, without you this referral system I have would have been useless!

  • #5
    Regular Coder
    Join Date
    Jun 2002
    Posts
    905
    Thanks
    23
    Thanked 5 Times in 5 Posts
    anytime


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •