Top posters with total number of members

Displays Top posters with total number of members like onĀ 

<?php $users = db_query(“SELECT COUNT(nid) AS count, {users}.uid, {users}.name FROM {node} LEFT JOIN {users} ON {node}.uid = {users}.uid WHERE {node}.uid != 0 GROUP BY uid ORDER BY count DESC LIMIT 5”);
while ($user = db_fetch_object($users)) {

Leave a Reply

Your email address will not be published. Required fields are marked *