Jump to content


Photo

Db design question


  • Please log in to reply
1 reply to this topic

#1 chinni

chinni
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 05 February 2003 - 09:27 PM

Hello everybody,

Question: topic, under that sub-topics,under that articles

For each topic there could be some 20 sub-topics and for each subtopic there could be some 1000 or 2000 or more articles.

For example, if i have a topic 1 and under that sub-topic1, sub-topic2, sub-topic3, sub-topic4 and if have 1000 or 2000 articles for each subtopic, then i cant imagine the size now;-)

So, could you please tell me the best idea how i can get the design.

But, this is true: For each topic, there are many sub-topics and for each sub topic there are many articles.

My previous design was: 3 tables-[topic(topic_id, topic_name), subtopic(subtopic_id, topic_id, subtopic_name), articles(article_id, subtopic_id, article_name, article_content)

How could you suggest me now??each topic a table or some thing like that.

A nice explanation would help me more.

Thank you so much

#2 axyonline

axyonline
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 15 February 2003 - 11:06 AM

u can do that like this:
u create a table
than create groups
than insert the articles to this groups
u can find group example in mysql manual
see u later...
php-mysql freak. electronic engineer student. [br]creative webmaster.and ask for more :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users