Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Oct 2008
    Location
    Poland
    Posts
    381
    Thanks
    150
    Thanked 2 Times in 2 Posts

    Wordpress filter comments and find most commenting people

    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

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    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.

  • #3
    Regular Coder
    Join Date
    Oct 2008
    Location
    Poland
    Posts
    381
    Thanks
    150
    Thanked 2 Times in 2 Posts
    Yes, Wordpress does use MySQL and this data is saved in this database.

  • #4
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •