Hello i have this table which contains users and the amount of points they have and i want to display the table starting from the users with the highest points but when i try the code below what it does is it shows the most common amount of points.
SELECT * FROM users ORDER BY points ASC
But instead of
User | Points
Bob 20
Jon 16
Abu 16
Eli 15
It does
User | Points
Jon 16
Abu 16
Bob 20
Eli 15
See shouldn't 20 be on top? it does it by most common points any help I am new to PHP
EDIT: Thanks to Hanky 웃 Panky i realized what i needed to do
ORDER BY CAST(points AS unsigned) DESC
Is the correct way.
Your Points field must be a String to be interpreted that way. Cast it as a number( if you cant change data type to become a number permanently) and you are good.
SELECT * FROM users ORDER BY CAST(points AS unsigned) ASC
And for a Descending order, use DESC instead of ASC
use
QUERY
SELECT * FROM users ORDER BY points DESC
for descending order
Please, change of type points string to integer or numeric type.
ALTER TABLE tablename MODIFY columnname INTEGER;
ALTER TABLE users MODIFY points INTEGER;