OK! I'm beating my brains out on this one and when I do that it usually means the answer is simple. So with that in mind I'll go forth with risk of total embarrassment. 
I'm developing my first database driven web site with the following idea.
1. Users can write articles basically about anything.
2. I want to organize the articles based on topics. Which can extend to any number of subtopics.
Here's the Problem:
I need to create a table for the topics. And the topics should be tracable through the topic uid which would be saved with the article.
For example:
Some one would like to write an article for the following topic and sub topics.
Products:Cars:Chevrolet:Corvette
So what should the table look like and how can I retrieve the data from the topic uid saved with the article? I磛e read somewhere about parent/child system but I can't recall how it works.
Please.....any ideas are welcome.
-Scott
I'm developing my first database driven web site with the following idea.
1. Users can write articles basically about anything.
2. I want to organize the articles based on topics. Which can extend to any number of subtopics.
Here's the Problem:
I need to create a table for the topics. And the topics should be tracable through the topic uid which would be saved with the article.
For example:
Some one would like to write an article for the following topic and sub topics.
Products:Cars:Chevrolet:Corvette
So what should the table look like and how can I retrieve the data from the topic uid saved with the article? I磛e read somewhere about parent/child system but I can't recall how it works.
Please.....any ideas are welcome.
-Scott