Xyphon Posted March 1, 2009 Share Posted March 1, 2009 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)) { Link to comment https://forums.phpfreaks.com/topic/147464-desc-only-reading-first-digit/ Share on other sites More sharing options...
PFMaBiSmAd Posted March 1, 2009 Share Posted March 1, 2009 Your field type is VARCHAR/TEXT. Change it to INT so that your numbers are treated as numbers instead of strings. Link to comment https://forums.phpfreaks.com/topic/147464-desc-only-reading-first-digit/#findComment-774045 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.