Topic: Selecting the First Post...
Shouldn't there be a column like "topics.first_post_id"? I am trying to create a page that will display the first post of every topic in a given forum, however PunBB seems to determine the first post by selecting the lowest posts.id number. This effectively works, but it isn't exactly an elegant solution in my book. It seems to me that it would just be much better if there was simply a "topics.first_post_id" column, so that one could simply retrieve the first post and discard the rest.
Has anyone else had this problem? What solution if any have you used to get just the first post?
