alaa/snippets/manalaa_top_20_commenters.php

<ul>
<?php
$query = "select uid,name,homepage,count(cid) as c from comments group by name,uid,homepage,mail order by c desc limit 20";
$result = db_query($query);
while ($row = db_fetch_array($result)) {
if ($row['uid'] != 0) {
$link = l($row['name'], "user/".$row['uid']);
} else {
$link = l($row['name'], $row['homepage']);
}

?>
<li><?php echo $link;?> : <?php echo $row['c']; ?></li>
<?php } ?>
</ul>
1	<ul>
2	<?php
3	$query = "select uid,name,homepage,count(cid) as c from comments group by name,uid,homepage,mail order by c desc limit 20";
4	$result = db_query($query);
5	while ($row = db_fetch_array($result)) {
6	if ($row['uid'] != 0) {
7	$link = l($row['name'], "user/".$row['uid']);
8	} else {
9	$link = l($row['name'], $row['homepage']);
10	}
11
12	?>
13	<li><?php echo $link;?> : <?php echo $row['c']; ?></li>
14	<?php } ?>
15	</ul>