22.02.2015, 08:00
Are you sure you're storing not just their current session but their overall session time in hour minute and second?
Also, I'd suggest(just my own opinion) to remove the "Username" after the number, it just boggles it up.
EDIT: I think I just realized I may have misunderstood you. You need to prioritize your ORDER BY as follows:
Not tested but I think that achieves the desired result.
Also, I'd suggest(just my own opinion) to remove the "Username" after the number, it just boggles it up.
EDIT: I think I just realized I may have misunderstood you. You need to prioritize your ORDER BY as follows:
pawn Код:
SELECT `Hour`, `Min`, `Sec`, `Username` FROM `players` ORDER BY `Hour` DESC, `Min` DESC, `Sec` DESC LIMIT 10