WordPress.org

Ready to get started?Download WordPress

Forums

SQL Query Help (1 post)

  1. trmtnbike
    Member
    Posted 7 years ago #

    I originally posted this to the Themes and Templates forum, but thought I may get more help here.

    Is anyone aware of a way to query for the date and time a category last had a post added to it?

    Please note: I cannot rely on the timestamp of the most recent post in the category, as they do not necessarily reflect the date in which a post was added to a category. For instance, if a post was made on August 1, 2005, and was then added to a category on July 20, 2006, I would want a way to display that the category was last updated on July 20, 2006.

    I added a timestamp to the post2cat table a long while ago to give myself this functionality, but was hoping that someone - with more knowledge of the WordPress DB schema than I - would know of a way around doing so.

    The ultimate aim is to make my photoblog theme more easily distributable.

Topic Closed

This topic has been closed to new replies.

About this Topic