Sorting MYSQl table ascending

[dink87522]

I am using

$query = "SELECT * FROM Highscores ORDER BY score DESC"; 

to select data from a table called highscores and a field called scores. I wish to sort the data in descending order (i.e. highest value first).

 

It sort of works, ie.: it does:

9

8

7

6

5

4

3

2

13

12

11

1 etc, how do I make 11, 12, 13 show at the top?

 

[dink87522]

Title should read descending, not ascending sorry.

[.josh]

change your column data type to something numerical instead of string based.