Skip to:
Content
Pages
Categories
Search
Top
Bottom

re-sorting posts by date?

Viewing 1 replies (of 1 total)

  • affacat
    Member

    @affacat

    this appears to do the trick:

    UPDATE

    bb_topics

    set topic_time =

    (SELECT bb_posts.post_time

    from bb_posts

    where bb_posts.topic_id=bb_topics.topic_id

    ORDER BY bb_posts.post_time DESC LIMIT 1)

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.