You may want to post what you have tried so others can give feedback.

In your data structure I do not see anything about users.

>Hi there!
>I´m developing a forum engine with Perl/Oracle8i (linux) and I have a little question (I used to work with MySQL & SQL Server).
>
>I have currently 3 tables:
>
>- forums: forumID, areaID, title (...)
>- areas: areaID, name (...)
>- posts: ID, forumID, type (topic/message), parentID, subject (...)
>
>I think the table design is ok (comments are welcom), and I want to select this information in the less number of querys as possible (I think that it´s possible to do it in only one):
>
>- forum area
>- forum name
>- number of topics
>- number of replys (to topics) in forum*
>- last post
>
>I only have problems getting the number of topics and replys to the forum. I´m not familiarized at all with some oracle querys and nested querys, but I think that it´s possible to get that info in only one query...
>
>Can anyone help me with this?
>
>Thanks!