sorting problem(mysql, is it a bug?)

goaman

Hi guys,
I'm trying to sort the scores from big to smaller numbers.

ie. 100..80..50..30..10



$query = "SELECT username, scores FROM gameXE ORDER BY `scores` DESC LIMIT 0, 5";
$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
list($player, $scores) = $row;

echo $player. ' [' .$scores. ']&nbsp;';
}

output: userA[80] userX[50] userB[30] userG[20] userR[100]

it suppose to sort, 100......20, but somehow the sorting is messedup..

Do u guys have any clue whats wrong here? pls lend me a hand.. 🙂

TIA

bpat1434

Seems to be a bug in your mySQL, what version are you running? It works fine for me (php5 & mySQL 5.1).

~Brett

goaman

oh thanks for the reply, darn, I thought this is a bug..

I'm using phpMyAdmin 2.6.2-Debian-3sarge1 and MySQL 4.1.11.

tunage

Is your score field an int? If its a char it would explain it.

bpat1434

That's true..... I was using the field as an INT type....

~Brett

goaman

thanks guys... it's working now... it was TEXT, damn I didn't know "text" type cannot be sorted normally, it's working jst fine after changing into "INT" type...

🙂

bpat1434

Text can be sorted normally, if you are actually filling it with TEXT. Numbers are integers, and won't be sorted normally (obviously). But if you were to order by a text field (like username) it would go alphabetically.

~Brett

goaman

thats true.. thanks ^_