[SOLVED] not in right order

[brem13]

hey, im trying to sort data from a table in desc order, but the results will show like this

 

8

7

5

2

11

1

1

1

 

here is the code i use

$result = mysql_db_query('rant_brem', "select * from `all` WHERE approved = 'Yes' AND yes > 0 ORDER BY yes DESC LIMIT 250") or die (mysql_error());

any reason why?

 

[PFMaBiSmAd]

Because your column type is not INT. It is some char/text and that is how strings are sorted. Columns holding numbers should be a numeric type not a char/text type.

[brem13]

thanks you!