[MySQL] Top Online
#6

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:

pawn Код:
SELECT `Hour`, `Min`, `Sec`, `Username` FROM `players` ORDER BY `Hour` DESC, `Min` DESC, `Sec` DESC LIMIT 10
Not tested but I think that achieves the desired result.
Reply


Messages In This Thread
[MySQL] Top Online - by ReD_HunTeR - 22.02.2015, 05:48
Re: [MySQL] Top Online - by Naresh - 22.02.2015, 05:51
Re: [MySQL] Top Online - by CalvinC - 22.02.2015, 06:10
Re: [MySQL] Top Online - by JeaSon - 22.02.2015, 07:43
Re: [MySQL] Top Online - by ReD_HunTeR - 22.02.2015, 07:52
Re: [MySQL] Top Online - by Extremo - 22.02.2015, 08:00
Re: [MySQL] Top Online - by JeaSon - 22.02.2015, 09:15
Re: [MySQL] Top Online - by Vince - 22.02.2015, 09:50
Re: [MySQL] Top Online - by Extremo - 22.02.2015, 09:52

Forum Jump:


Users browsing this thread: 5 Guest(s)