Getting the rank (ORDER BY position) of a record in a table

[James Spibey]

Hi,

I have an interesting problem. I have a table which contains a series of names and times

entry_id name time
1 john 1:32
2 bill 1:54
3 sarah 1:12


What I need to be able to do is for each of those records to be able to display their 'ranking' based on the time column.

What's the best way to do this? It needs to be scalable to many thousands of records so performance is definately a priority.

Thanks