WordPress.org

1. petitpoulain
   Member
   Posted 5 years ago #

   I want to count, using the e-mail as reference, how many times the people had commented on my blog.

   On the comment template, how to get the 'comment_author_email' of the commenter?? It must be where says HERE

   <?php
   $totalcomments = $wpdb->get_var("
   SELECT COUNT(comment_ID)
   FROM $wpdb->comments
   WHERE $wpdb->comments.comment_author_email='HERE'"); 
   
   echo $totalcomments; 
   
   ?>

   thanks, and if anyone know an easier way to to it tell me please ^^

2. Otto
   Tech Ninja
   Posted 5 years ago #

   <?php
   $email = get_comment_author_email();
   $totalcomments = $wpdb->get_var("
   SELECT COUNT(comment_ID)
   FROM $wpdb->comments
   WHERE $wpdb->comments.comment_author_email='$email'"); 
   
   echo $totalcomments;
   ?>

3. petitpoulain
   Member
   Posted 5 years ago #

   thanks ;)

   just as i post i noticied... XD
   if i had posted before would be a lot easier.

Topic Closed

This topic has been closed to new replies.