Hi ranchers. I want to create a forum (like javaranch!!) to learn. but actually, I don't know what is the best database schema to use here. so, can some one help me here to create this schema ? ofcours, as I told you, I want to create a forum like java ranch forum (closed topic, hot topic, number of posts.....) I have downloaded phpbb forum to see if I can learn something, but ..... all I can say is, O MY GOD !! I don't know why people say that the development of php application is rapid. I look at the source and I don't understand any thing. I saw just functions, there is no html tags, and each page is about 1000 line !!! I want to ask here someone of java ranch moderators if possible (and if this is llegal): how java ranch knows the (New posts since your last visit) ? can you explain this to me ? how do you perform the (Closed Topic) ? my first solution is each post has a field in the database to indicate if it is closed or not.. thanks alot.