Member Avatar for Acute

Hi everybody,
I want to make a forum somehow similar to Daniweb. My forum also has different categories like academic, social, sell, etc. So, how should I correctly design the database?
I wanted to create different databases for each category, for example database named "Social", and then create a new table for each new thread in this database and the created table (thread) will contain columns like "replier_name", "date", "text". However, i don't think this is the optimal way of designing the database...

Thnx

Edited by Acute because: n/a
  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Dani

A new table for each thread is like a separate hard drive for each Word document you save!

I think what you mean is you want to create one database. One table in the database contains all of the threads. And then columns for replier_name, date, text and category_name.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.