Order by des Not working

[Monk3h]

Why isnt this brining back 10 people from the players database ordered most to least Chatlines. :S

 

<?php
$tsel = mysql_query("select * from players order by chatline desc limit 10");
while ($top = mysql_fetch_array($tsel)) {
	print "<tr><td>$top[user] ($top[id])</td><td>$top[chatline]</td></tr>";
}
?>

 

 

It brings back the data needed.. It just dosnt order it by chatlines..

[PFMaBiSmAd]

Chatline is probably strings and it is probably ordering them correctly (for the data type they are.)

 

You would need to post an example of what your data is and what results you are getting and what you want it to be.

[Monk3h]

Everytime some one says somthing in chat it changes there chatlines by +1

 

I want to display the top 10 chatty people.. It should display it by Chatlines but instead its ordered like this.

 

Lines in Chat

Name (ID) Chat Lines

Mooie (59) 21

SaRawr (89) 2

Monk3h (2) 18

andis0311 (22) 0

Dunk3r (1) 0

 

[AndyB]

21,2,18,0,0 is sorted descending for STRING values.  You need a NUMERIC type to sort numerically.

 

That's what PFMaBiSmAd suggested.

[Monk3h]

How do i do that?

[AndyB]

How do i do that?

 

database field definition

[sasa]

try

ORDER BY chatline+0