PHP Magic Book – Free PHP Scripts, Tutorials and Downloads» Blog Archive » Display the Total Number of Comments on Your WordPress Blog

Display the Total Number of Comments on Your WordPress Blog

November 16th, 2008 | by King | Posted in » Hacks, WordPress

In this tutorial we will learn how to show total number of comments at your blog using the $wpdb object. Use the following code where you want to display total number of comments at your blog.

<?php
$numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'");
if (0 < $numcomms) $numcomms = number_format($numcomms);
?>

Here $numcomms variable contains the total number of comments posted on your WordPress blog. To display this number, simply do something like:

<?php echo "There's ".$numcomms." total comments on my blog"; ?>

You can combine the code as well like following:

<?php
$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";
?>

This should show you that how many comments your blog has got.

Tags: blog, customize
Posted in: Hacks, WordPress
Post's RSS » RSS 2.0
Post's Comments RSS » RSS 2.0

Digg This Post

Bookmark To Delicious

Stumble This Post

Add To your Technorati Favourites

Email To A Friend

displaying the number of comments for a post in wordpress

40 Responses to “Display the Total Number of Comments on Your WordPress Blog”

Mar 28, 2009
Tony @ free sports betting picks Says:

Thanks for your help on the comment feature using Wordpress.

Tony
May 30, 2009
Steve Patterson Says:

Hey thanks, nice! Good way to show off how popular your blog is by the comments.
Jul 29, 2009
ragi Says:

Good tut but I can’t stylize it. How can I make the numbers big and red?
Sep 29, 2009
King Says:

@ragi: Just put all this code in a div block and give that div some style.
Oct 9, 2009
Durkin Says:

worked great and lets me thank all the readers and commentators, thanks!
Oct 11, 2009
Edward Lane Says:

Super-Duper site! I am loving it!! Will come back again – taking your feeds too now, Thanks.
Oct 11, 2009
kempozone Says:

I‘m sure many of you are like me and one of the first things you do in the morning is head here and check out the new post. Along with seeing the new posts, I’m also always checking out the blog roll rss feed and watching them grow, or shrink sometimes. In one of my past …but all in all excellent site. Keep it up!
Nov 20, 2009
Trackback - Cheap Internation Call >> How to make cheap international call Says:

,..] http://www.phpmagicbook.com is other interesting source of tips on this issue,..]
Dec 30, 2009
Deepu Balan Says:

Thanks for the tip. But I want to show the total count of comments and trackbacks in the homepage. By default its showing only the comment count now. How can I do this?

Thanks in advance!

-Deepu