<?php
include("config.php");
$sql = mysql_query("SELECT author,COUNT(*) AS author FROM files GROUP BY author ORDER BY BLA DESC,author ASC");
while($row = mysql_fetch_array($sql)) {
$author = $row['author'];
echo "$author";
}
<?php
include("config.php");
$sql = mysql_query("SELECT author,COUNT(*) AS BLA FROM files GROUP BY author ORDER BY BLA DESC,author ASC");
while($row = mysql_fetch_array($sql)) echo "Автор:".$row['author']." Брой: ".$row['BLA']."<br />";