Sort MySQL in Human

[figu120]

here's the code:\[code\]$sql_namesResult = mysql_query("SELECT name FROM `scrimaprovedlist` ORDER BY `scrimaprovedlist`.`eorank`");\[/code\]eo rank is a NUMERICAL value for a rank (general, colonel, ect).The problem is, when i set myself for 1, i am the top, but comes rank 10, instead of rank 2. how do i edit this to make it show in order:123102030I'm currently using "rank" instead of "eorank" because it is easier. but the problem is i have to manually edit the ranks over and over again so that they show in the correct order. Any ideas?Viewable at http://www.thexcrew.com/modules.php?name=Roster