out of order DB response

when i run this code, it lists the values out of order..

Code:

<?php

//Top 10 C-pts
$result = dbquery("SELECT user_name, user_clanrank, user_id, user_cpts 
FROM ".$db_prefix."users 
ORDER BY user_cpts 
DESC LIMIT 0,10
");
echo "<table width='100%' cellpadding='0' cellspacing='1' border='0' class='tbl'>";
if (dbrows($result)!=0) {
while ($data=dbarray($result)) {
include BASEDIR."colors2.php";
echo "<tr>
<td class='tbl2' align='left'><a style='color: $mm_color' href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>
".$data['user_name']."</a></td>
<td class='tbl2' align='right'>".$data['user_cpts']."</td>
</tr>";
}
}
echo "</table>";
//

?>

also, simply running this DB query will give me same results:

Code:

<?php

dbquery("SELECT user_name, user_clanrank, user_id, user_cpts 
FROM fusion_users 
ORDER BY user_cpts 
DESC LIMIT 0,10")?>

i receive this order of results, 91, 60, 60, 60, 50, 50, 50, 250. 250 shold be first

what is the datatype of "user_cpts"?

try... ORDER BY user_cpts*1 DESC...

nvm, it was set as VARCHAR(255) so i changed it to BIGINT(9) and it orders it fine, strange

nvm, it was set as VARCHAR(255) so i changed it to BIGINT(9) and it orders it fine, strange

is not strange, if you want order by a number you need a number and not a string

[Guest]

[62.871]

Googlebot, Msnbot, hobbit, Yahoo crawler