View Full Version : Wordpress filter comments and find most commenting people

06-28-2011, 08:57 AM
Hello, I would like to award the most commenting people every month.
In my blog people cannot register. So I can select the users only by email address and not by username.

I would like to:

Filter all the comments from day June 1 to June 30;
Sort ascending/descending per number of comments;
See the email address of the commenters;

In this way I can write to the person that commented the most and send the award.

How can I do that?
Thank you

06-28-2011, 02:39 PM
Does your site use MySQL? Do you have direct access to write queries to the database?

If not this isn't a question for a mysql forum.

06-28-2011, 02:46 PM
Yes, Wordpress does use MySQL and this data is saved in this database.

06-28-2011, 06:54 PM
Okay that's good that you have access to the table so you know you can write your own queries.

So now you need to show us the table(s) structure and what attempt you have made to join the data. we can help you from there.

Of course you can always pay someone to do it if you don't want to do some of the work yourself.