josiec09 Posted December 8, 2014 Share Posted December 8, 2014 (edited) Ok i am building a custom PHP forum system for my site and i am pretty much done, but having troubles with one thing linking categories with boards (aka forums in database). I will start by covering my database layout Categorycat_id | int(8) | primary | auto incrcat_name | var(255)|2|Test 2|3|Test 3|1|Test 1Forumid | int(8) | primary | auto_incrforum_cat | int(8) <-- forum cat "category" is just ID of category it belongs toname | var(255)desc | var(255) position | smallint(6)|1|1|Test| Just a simple forum test|2|3|More Test | Just a 2nd test forum|3|1|Bugs| Bugs and related go here and this is my php for displaying the boards, like i said not sure how to go about adding categories. <?php$dn2 = mysqli_query($conn,'select id, name from forum_cats where id order by id asc');while($dnn2 = mysqli_fetch_array($dn2)){?><div class="panel-heading"><table class="cat-table"> <tr> <td width="81%"><h3 class="panel-title"><span class="glyphicon glyphicon-home"></span><?php echo $dnn2['name']; ?></h3></td> <td width="12%"><h3 class="panel-title">Topics</h3></td> <td width="7%"><h3 class="panel-title">Replies</h3></td> </tr></table></div><div class="panel-body"><table class="cat-table"><?php$dn1 = mysqli_query($conn,'select b.id, b.name, b.description, b.position, (select count(t.id) from topics as t where t.parent=c.id and t.id2=1) as topics, (select count(t2.id) from topics as t2 where t2.parent=c.id and t2.id2!=1) as replies from boards as b group by b.id order by b.position asc');$nb_cats = mysqli_num_rows($dn1);while($dnn1 = mysqli_fetch_array($dn1)){?><tr class="cat-col"> <td class="cat-row" width="84%"><a href="topics.php?id=<?php echo $dnn1['id']; ?>" class="title"><?php echo htmlentities($dnn1['name'], ENT_QUOTES, 'UTF-8'); ?></a> <div class="description"><?php echo $dnn1['description']; ?></div></td> <td class="cat-row" width="12%"><?php echo $dnn1['topics']; ?></td> <td class="cat-row" width="7%"><?php echo $dnn1['replies']; ?></td> </tr><?php}?> </table></div><?php}?> Image attached is what i am aim for... So as of right now categories are displaying right but all boards show up under all categories...demo in reply Edited December 8, 2014 by josiec09 Link to comment Share on other sites More sharing options...
josiec09 Posted December 8, 2014 Author Share Posted December 8, 2014 (edited) working demo of what i have so far http://animeelite.cz.cc/forums.php Edited December 8, 2014 by josiec09 Link to comment Share on other sites More sharing options...
justsomeguy Posted December 8, 2014 Share Posted December 8, 2014 Your SQL statement on line 18 isn't selecting only the forums for the current category, it's selecting all of them. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now