psilocibe
Member
- Joined
- Jul 9, 2007
- Messages
- 480
- Reaction score
- 8
This shows the level of guilds,
I'm doing a top 5 guilds level, how do I sort in ascending order.
do this work in sql?
Sry my english.
I'm doing a top 5 guilds level, how do I sort in ascending order.
do this work in sql?
Code:
while($x<=5) {
$sumav = $SQL->query("SELECT AVG(`level`) AS `level_avg` FROM `players` LEFT JOIN `guild_membership` AS `gm` ON `gm`.`player_id` = `players`.`id` WHERE `gm`.`guild_id` = ".$x."")->fetch();
$x++;
echo round($sumav['level_avg']);
echo '<br>';
}
Last edited by a moderator: