Sort High To Low SQL PHP

Question

I have a big problem with the selection of the table. I want to show me from the highest to the smallest, just that it appears to me like this

NAME               `POINTS`

John Doe            0
John Doe2           432
John Doe3           64
John Doe4           0
John Doe5           138

I want to show from the highest to the smallest and in the database there is someone who has over 432 points just does not show it

 <?php 
$query = sql()->query('SELECT * FROM `PlayersData` WHERE `Points` BETWEEN 0 AND 1000 LIMIT 5');
if( $query->num_rows == 0 ) {
    echo '<div class="nores">No records found.</div>';
} else {
    while( $row = $query->fetch_object() ) {
        $row = (object) $row;
    ?> 
    <div class="row">
                  <div><?php echo $row->SteamID ?></div>
                  <div>
                    <?php echo $row->Points ?>                      </div>
                </div>
    <?php
    }
}

?>

You need to do `ORDER BY Points DESC` to get _from the highest to the smallest_. (After WHERE, before LIMIT.) — jarlh, Dec 05 '19 at 20:43
@jarlh I tried to do this only because it shows me those who have points below 100 having others with values greater than these — Sebastian, Dec 05 '19 at 20:46
I don't understand what you mean? BTW, why the between 0 and 1000 condition? Don't you want users with more than 1000 points? — jarlh, Dec 05 '19 at 20:51

jarlh · Accepted Answer · 2019-12-05T20:59:53.253

3

Add an ORDER BY, use DESC to get the highest values first.

SELECT * FROM `PlayersData` WHERE `Points` BETWEEN 0 AND 1000
ORDER BY Points DESC 
LIMIT 5

If the data type isn't integer, cast it when ordering:

SELECT * FROM `PlayersData` WHERE `Points` BETWEEN 0 AND 1000
ORDER BY cast(Points as integer) DESC 
LIMIT 5

edited Dec 05 '19 at 20:59

answered Dec 05 '19 at 20:45

jarlh

42,561
8
45
63

https://i.imgur.com/F0KUhg9.png online view https://i.imgur.com/txZFQCw.png database view – Sebastian Dec 05 '19 at 20:49
I made a typo, 100 instead of 1000, which I corrected when I saw it. Make another try. – jarlh Dec 05 '19 at 20:51
well I want to start everything from 1000 down – Sebastian Dec 05 '19 at 20:52
Just what my query does, after the typo correction. – jarlh Dec 05 '19 at 20:53
not work...it looks the same – Sebastian Dec 05 '19 at 20:55
Column data type? Should be integer. – jarlh Dec 05 '19 at 20:58
sorry it was from the type of column I put varchar instead of INT – Sebastian Dec 05 '19 at 21:02
You should really alter that column data type to integer. Otherwise you will run into problems like this more times. E.g `Points BETWEEN 0 AND 1000`... – jarlh Dec 05 '19 at 21:03

Sort High To Low SQL PHP

1 Answers1