Search found 1 match

Go to advanced search

by bnordin
Mon Dec 15, 2008 4:05 pm
Forum: Bug reports
Topic: Sorting issue
Replies: 1
Views: 2492

Sorting issue

I'm a developer myself and noticed a classic issue. The scores are sorted as text and not by numbers. Therefore, 200 is > 1000. To get things to sort correctly, you should cast the number before sorting. MySQL Cast Example: ORDER BY CAST(score AS INT) However, a better alternative is to store the nu...

Go to advanced search