[SOLVED] Why won't this work, sort into descending.

[jack bro]

I have a leaderboard which i want to sort highest to lowest by rankpoints top 10 players I have this code.

 

  $c=mysql_query("SELECT * FROM users ORDER BY rankpoints DESC LIMIT 10");

  while($d=mysql_fetch_object($c)){

  echo "<tr><td><a href='profile.php?viewuser=$d->username'>$d->username</a></td><td>$d->totalref</td><td>$d->rank</td></tr>";

 

Don't sort into order for some reason.

 

Jack.

[CloudSex13]

Try:

 

$c=mysql_query("SELECT * FROM users ORDER BY rankpoints LIMIT 10 DESC");
while($d=mysql_fetch_object($c)){
echo "<tr><td><a href='profile.php?viewuser=$d->username'>$d->username</a></td><td>$d->totalref</td><td>$d->rank</td></tr>";

[Maq]

What datatype is the rankpoints field?

[premiso]

What is the field type of "rankpoints", it should be a numeric type (int etc) if it is not and it is a varchar or char, that is why.

[PFMaBiSmAd]

And show what you are actually getting.

[jack bro]

Was VARCHAR(100) now is INT(11) and still not working.

 

http://www.midcity-mafia.com/leaderboard.php

 

Jack.

[Maq]

What you're referring to is not what you're trying to ORDER BY.

 

You're outputting $d->totalref

 

but you're ordering by rankpoints, which is it?

[jack bro]

Wow, I'm such a goon, thanks Maq and everyone else, sorry for wasting your time.

 

Jack.