using PHP script for sorting sql database entries

Question

I need some help sorting my score value's of my sql database

    <table border = '2'>
    <?php

    $con = mysql_connect("localhost", "root", "");
    if(!$con)
    {
        echo "Could not establish connection to the database " . mysql_error();
    }

    $mydb = mysql_select_db("users", $con);
    if (!$mydb)
    {
        echo "Error selecting database " . mysql_error();
    }

    $mystatement = mysql_query("SELECT * FROM people");
    $dbcount = mysql_num_rows($mystatement);
    $selection = array(0 => "");
    $nameselection = array(0 => "");

    $i = 0; 
        while ($row = mysql_fetch_array($mystatement))
        {
        $selection[$i] = $row['score'];
        $nameselection[$i] = $row['username']; 
        //echo "<tr> <td>$row[username]</td> <td>$row[score]</td></tr>";
        $i++; 
        }
arsort($selection);
ksort($nameselection);

for ($x = 0; $x < $dbcount; $x++)
{
    echo "<tr> <td>$nameselection[$x]</td> <td>$selection[$x]</td> </tr>"; 
}


    ?>

    </table>

im trying to post the user's scores from my game to a table, sorting them from highest to lowest. I'm just stuck..

Yada · Accepted Answer · 2012-02-18 23:08:28Z

4

Change

$mystatement = mysql_query("SELECT * FROM people");

To

$mystatement = mysql_query("SELECT * FROM people ORDER BY score DESC");

Remove the array sort

arsort($selection);
ksort($nameselection);

answered Feb 18, 2012 at 23:08

Yada

31.5k25 gold badges105 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Josh Siegl Over a year ago

beautiful, i'm new to sql, didn't even know you could do that. thank you VERY much

Alberto De Caro Over a year ago

A tutorial can be useful.

Kavi Siegel · Accepted Answer · 2012-02-18 23:07:21Z

2

$mystatement = mysql_query("SELECT * FROM people ORDER BY score DESC");

answered Feb 18, 2012 at 23:07

Kavi Siegel

2,9942 gold badges26 silver badges33 bronze badges

1 Comment

Umbrella Over a year ago

+1 even though you were third to answer, you were first to include the correct fieldname, score

Valeh Hajiyev · Accepted Answer · 2012-02-18 23:11:55Z

2

Use ORDER BY in SQL query like this:

SELECT * FROM people ORDER BY score DESC

edited Feb 18, 2012 at 23:11

answered Feb 18, 2012 at 23:06

Valeh Hajiyev

3,2464 gold badges21 silver badges28 bronze badges

Comments

William Dixon · Accepted Answer · 2012-02-18 23:06:50Z

1

You can sort them DB-side using "Order by"

ie. SELECT * FROM people ORDER BY scores desc

answered Feb 18, 2012 at 23:06

William Dixon

1016 bronze badges

Collectives™ on Stack Overflow

using PHP script for sorting sql database entries

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related