[Vince]

Quote:

Originally Posted by xVIP3Rx I don't understand why do you use "LIMIT 0,10" and not just 10 though ?

That means: start from the 0th row and select the next 10, so shouldn't make a difference.

As for the problem: this is likely caused by the column being declared as a text type rather than an integer type, in which case the column will be sorted alphabetically (z-a and also 9-0) rather than numerically.