22.02.2015, 09:50
Store their online time in seconds only. Get rid of the hours and minutes. The maximum value the field can store would be 2147483647 seconds, which is about the equivalent of 68 years. That way you only need to store and sort one field and you can easily convert back to hours and minutes.
As for the short term solution, what Extremo posted should work. Each column in the 'order by' clause needs to have the sort order specified, otherwise it will default to ascending order.
As for the short term solution, what Extremo posted should work. Each column in the 'order by' clause needs to have the sort order specified, otherwise it will default to ascending order.