PrinceTaz Posted February 27, 2020 Share Posted February 27, 2020 Hey there, so as a personal project, I've been working on creating a forum software. You can check out what I have so far here: https://www.taziamoma.com/Forum/index.php What I'm currently having trouble with right now is connecting a Category with a forum with the threads inside of it. For example, I have a Category that has 3 forums attached to it. How do I link that in the database and how do I indicate which threads belongs to which forums? Quote Link to comment Share on other sites More sharing options...
requinix Posted February 27, 2020 Share Posted February 27, 2020 Do you have already have a concept of posts inside threads? How did you manage that? Quote Link to comment Share on other sites More sharing options...
PrinceTaz Posted February 27, 2020 Author Share Posted February 27, 2020 18 minutes ago, requinix said: Do you have already have a concept of posts inside threads? How did you manage that? I don't yet, I created the least complex stuff first. Like dynamically displaying forum and category names, registration/login system. Quote Link to comment Share on other sites More sharing options...
requinix Posted February 27, 2020 Share Posted February 27, 2020 Not sure I would call a registration and login system less complex than threads and posts, but I guess it depends... I suggest you take a look at MariaDB's knowledge base section on database theory. 2 Quote Link to comment Share on other sites More sharing options...
PrinceTaz Posted February 27, 2020 Author Share Posted February 27, 2020 (edited) 8 hours ago, requinix said: Not sure I would call a registration and login system less complex than threads and posts, but I guess it depends... I suggest you take a look at MariaDB's knowledge base section on database theory. Well only reason its less complicated to me is simply because I've done it so many times . I'll take a look at that. So my other idea was to create a tuple relating to each individual table. For example, for each forum, create a forum_cat attribute to define which category it belongs to. Same with topics/replies. Edited February 27, 2020 by PrinceTaz Quote Link to comment Share on other sites More sharing options...
requinix Posted February 27, 2020 Share Posted February 27, 2020 If you want forums to have/belong to multiple categories and replies to multiple threads, yes. But that second one doesn't sound right. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.