Only show # of approved comments WordPress

Francisco Javier Carazo Gil answers:

Hi Badnews,

In wp_comments table you should see comments. Well rows represent the next:
* comment_post_ID: post_ID foreign key
* comment_approved: 0 or 1

If you have this bug you could always do your own function and call it:

functions my_comments_number($zero, $one, $more, $post_id)
{
global $wpdb;

$comments_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1' AND comment_post_ID = '$post_id';" ) );

if($comments_count == 0)
echo $zero;
else if($comments_count == 1)
echo $one;
else
echo $more;
}


---

Jurre Hanema answers:

After you have un-approved all comments using your query, you can update the comment count of the posts with a query like this:


UPDATE wp_posts p SET comment_count = (SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = p.ID AND comment_approved = '1');


---