DESC only reading first digit.

[Xyphon]

Well, to sum it up nicely, I have a DESC query, and I have a while revolving around that desc.

 

But the desc only reads the first digit, so when displaying it it'll do something like

8

75

6

6

47

100

 

How do I make it read every digit?

 

Code1:

$ML_Result2= mysql_query("SELECT * FROM users ORDER BY Level DESC LIMIT $ML_LimitValue, $ML_Limit");

 

Code2:

while($row = mysql_fetch_array($ML_Result2))
{

[PFMaBiSmAd]

Your field type is VARCHAR/TEXT. Change it to INT so that your numbers are treated as numbers instead of strings.