/Top MySQL
#1

Can anyone reply with an example script of MySQL /top command?
Reply
#2

What shall that command do?

If you are trying to order something of a mysql table, you can use the "ORDER" and "LIMIT" atts of mysql.

E.g. to get the top 10 post counts of a userdb you can use a query like that
PHP код:
SELECT *  FROM `userORDER BY `postcountDESC LIMIT 10 
-> Order by postcount "DESC" -> Descending, highest first.
-> LIMIT 10 -> only returns the 10 highest
Reply
#3

Get top 10 players with high scores and show them in a dialog
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)