Топ потребители

[hackera]

Как мога да извеждам потребители, който имат най-много качени материали в базата данни.
Примерно: имам таблица material в нея имам полета id text author

 

[baso]

<?php
$query = mysql_query("SELECT * FROM `material` TOP ORDER BY `author` DESC LIMIT 5");
while ( $row = mysql_fetch_array($query) )
{
echo $row['author'];
}
?>

Така?

 

[emagi]

<?php
$query = mysql_query("SELECT author, COUNT(*) as bla FROM `material` GROUP BY `author` ORDER BY bla DESC");
while ( $row = mysql_fetch_array($query) )
{
echo "Брой:".$row['bla'].", автор:".$row['author'];
}
?>

 

[hackera]

<?php
$query = mysql_query("SELECT author, COUNT(*) as bla FROM `material` GROUP BY `author` ORDER BY bla DESC");
while ( $row = mysql_fetch_array($query) )
{
echo "Брой:".$row['bla'].", автор:".$row['author'];
}
?>

Точно. :?: