Hint pls

Hello,

I've plans to design a new webpage and maintain it.well, here it goes...

On the left side of my navigation, i have 3 different topics.Under each topic, i've several sub-topics.
so, when i click on Topic 1, lets assume 4 different subtopics are displayed.
Now under each sub-topic, there are can be some articles.Now, when i click on the article, the content is displayed.

So, in simple words, under 1 topic, there are several sub-topics and under each sub-topic, there are several articles.

well,somebody can give me a hint how my db should look like??will each article would be a table or each sub-topic should be a table??

Thanks for all your suggestions.

Here's how I would do it....

A table called topics:

id - unique id for each topic
name - name of topic
parent - id of parent topic that this topic is under. 0 if it is a top level topic.


A topic called articles
id - unique id for each article
title - article title
content - article content
topic_id - if of topic that article belongs to.


To pull all top level topics, just

select * from topics where parent = 0

to pull all sub level topics for a upper level topic with an id of 3:

select * from topics where parent = 3

to pull all articles for a sub-topic with id of 7:

select * from articles where topic_id = 7


Hope that helps....