How to display total number of comments on WordPress blog
Filed under Labs
Place below code in your WordPress template where you want to display the total number of comments on WordPress blog.
<?php
$total_comments = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'");
if (0 < $total_comments) $total_comments = number_format($total_comments);
?> |
Posts you may like:
Delete records within a specific Range from MySQL table
If you want to delete a range of records from MySQL table then you can …
php pagination code example using MySql database
Here is a working code for pagination using PHP and MySql database. Its is tested …
How to include php headers on html site
PHP is a powerful language for web development, it have many in built functions. Here …
Meta refresh tag HTTP-EQUIV “REFRESH”
The refreshing time of a webpage can be define by using html tag HTTP-EQUIV “REFRESH”. …
Open link in a new window
Here is some ways to make html links for a webpage, it will be useful …
