SQL query to order custom author archive by recent activity (1 post)

  1. drewbarden
    Posted 5 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic