top 50 meeste links

SELECT count(*) rank from links group by linkname order by rank;

SELECT count(*) rank FROM links GROUP BY linkname ORDER BY rank;

select count(*) rank from tabel group by url order by rank

SELECT count(*) rank FROM tabel GROUP BY url ORDER BY rank

$query = "SELECT * FROM `urls` ORDER BY `hits` DESC LIMIT 50;";
$result = mysql_query($query);
while ($obj = mysql_fecth_object($result)) {
  echo "<a href= \"".$obj->url."\">".$obj->url."</a><br>\n";
}

$query = "SELECT * FROM `urls` ORDER BY `hits` DESC LIMIT 50;";
$result = mysql_query($query);
while ($obj = mysql_fecth_object($result)) {
  echo "<a href= \"".$obj->url."\">".$obj->url."</a><br>\n";
}