3 replies to this topic

[TutNation]

I have installed a point system and when I try and order the leaderboard by the most points to the least points its ending up like this:

50
235
110

instead of

235
110
50

here is my query:
SELECT * FROM `TABLE` ORDER BY `points` DESC LIMIT 0,10

[Mr. Matt]

What column type are you using, you may get somthing like that if your using varchar, in that case you need to use INT or another numerical column type so it can order by how its meant to be.

Matt

[TutNation]

oh, duh' of course, I forgot, thanks

[Mr. Matt]

no worries.