Display total number of comments

You can easily show of how many comments there are on your WordPress blog by adding this clever little snippet.

Add this code to where you want to show the total amount of comments.

Code Snippet:

$numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"); 
if (0 < $numcomms) {
	$numcomms = number_format($numcomms); 
	echo "There's ".$numcomms." total comments on my blog";

Posted in Comments