How To List Top Commentators in WordPress

Are you looking for a way to list the top commentators on your blog? This snippet will let you display the top five commentators using a function.

Instructions:

1. Add this code to your theme’s functions.php file or in a site-specific plugin.

function top_comment_authors($amount = 5){

	global $wpdb;

	$results = $wpdb->get_results('
		SELECT
			COUNT(comment_author_email) AS comments_count, comment_author_email, comment_author, comment_author_url
		FROM
			'.$wpdb->comments.'
		WHERE
			comment_author_email != "" AND comment_type = "" AND comment_approved = 1
		GROUP BY
			comment_author_email
		ORDER BY
			comments_count DESC, comment_author ASC
		LIMIT '.$amount

	);

	$output = "<ul>";
	foreach($results as $result){
		$output .= "<li>".$result->comment_author."</li>";
	}
	$output .= "</ul>";

	echo $output;

}

2. Add this function snippet to one your theme’s templates to list the top commentators on your blog.

<?
         top_comment_authors();
?>

Note: If this is your first time adding code snippets in WordPress, then please refer to our guide on how to properly copy / paste code snippets in WordPress, so you don’t accidentally break your site.

If you liked this code snippet, please consider checking out our other articles on the site like: 9 Best SEO Tools to Grow Your Website Traffic, FAST!