Forum Subject: phpbb recent posts block

Posted on: 01/10/03 04:59am
By: Anonymous (Anonymous)

There was an example of displaying 10 recent posts, but what everyone needs is 10 recent posts in all forums, not just the one you specify. $sql = "SELECT t.topic_title, t.topic_id, f.forum_id FROM forum_topics t, forum_forums f, forum_posts p WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id ORDER BY post_id DESC LIMIT 10"; this does the thing, but shows only 1 most recent post. Any hints?

phpbb recent posts block

Posted on: 01/10/03 10:29am
By: Tony

You need a GROUP BY clause. Specifically you need to GROUP BY the ID fo the main thread. That will collapse all posts from the same thread an you should get 10 unique threads.---The reason people blame things on previous generations is that there's only one other choice.

phpbb recent posts block

Posted on: 01/13/03 11:37pm
By: Anonymous (Anonymous)

Good idea I suppose. I just didn't want to dump stuff from my private forums for the world to see.