- /* most games */
- $result = DB_query_array_all("SELECT fullname, COUNT(*) as c " .
- " FROM Hand".
- " LEFT JOIN User ON User.id=user_id".
- " GROUP BY user_id".
- " ORDER BY c DESC LIMIT 7" );
- array_unshift($result,array("Name","Number of games"));
- echo output_table($result,"Most games","stats");
-