Support » Fixing WordPress » SQL query to order custom author archive by recent activity

  • So I’ve got this great function that selects recent comments outside of the loop, and displays them chronologically (for instance in the sidebar). Here it is at pastebin.

    Next, I’ve got a for loop to create a grid of authors, seen here.

    What I want, is to take pieces of both. I want to display all the authors like they are currently, in the second pastebin, but ordered by latest activity. The idea is to display the authors who comment, first, and to leave those with no activity by the wayside.

    I know this is possible by combining those bits of code, but unfortunately my grasp on SQL is pretty wimpy. I’m looking for someone to simply tell me what to do!

  • The topic ‘SQL query to order custom author archive by recent activity’ is closed to new replies.