按此格式的SQL顺序（0：0：0.8）H：M：S.MS - ORDER BY / ASC不工作

$result = mysql_query("
    SELECT `runner`,`finished` 
    FROM `runs` 
    WHERE `gamename`='$_SESSION[game]' 
    ORDER BY finished ASC
");

finished is the time H:M:S.MS

it doesn't sort at all.

Here is the data:

0:0:5.1 
0:0:5.2 
0:0:5.4 
0:0:5.7  
0:0:7.0  
0:0:8.9 
0:0:9.3 
0:0:9.8 
0:10:25.2    
0:13:15.2    
0:1:27.1     
0:1:50.4 
0:2:27.9 
0:5:30.9

Your ordering is probably going screwy because "finished" is a text field. Try converting it to a date field in your order by clause:

...
ORDER BY STR_TO_DATE(finished, '%h:%i:%s.%f')

Here is a way to do it even if it's a little complex :

SELECT * FROM runs
ORDER BY
substring_index(finished, ':', 1),
substring_index(substring_index(finished, ':', 2), ':', -1),
substring_index(substring_index(finished, ':', -1), '.', 1),
substring_index(substring_index(finished, ':', -1), '.', -1)

Test here