alaa/snippets/manalaa_top_commented_nodes.php

<?php 

$query="select c.nid, c.comment_count, n.title from node_comment_statistics c, node n where n.nid=c.nid order by c.comment_count desc limit 20";

$result=db_query($query);

echo "<ul>";
while ($node = db_fetch_object($result)) {
echo "<li>".l($node->title, "node/$node->nid")." : $node->comment_count </li>";
}
echo "</ul>";

?>
1	<?php
2
3	$query="select c.nid, c.comment_count, n.title from node_comment_statistics c, node n where n.nid=c.nid order by c.comment_count desc limit 20";
4
5	$result=db_query($query);
6
7	echo "<ul>";
8	while ($node = db_fetch_object($result)) {
9	echo "<li>".l($node->title, "node/$node->nid")." : $node->comment_count </li>";
10	}
11	echo "</ul>";
12
13	?>