rockinaway Posted January 16, 2007 Share Posted January 16, 2007 I have a table which contains both forum and categories for my board. I want to list both the forums and categories. They are sorted if they are forum or category by their type and also have a parent ID to category.The problem I get is that if there are 2 forums for same category, the category is repeated for every single forum. How can I get the forum for the same category just to view under one category? Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted January 16, 2007 Share Posted January 16, 2007 Could you post the code your using?-Andy Quote Link to comment Share on other sites More sharing options...
rockinaway Posted January 16, 2007 Author Share Posted January 16, 2007 Sorry I am not allowed to post all of it, but which parts would you be interested in?I figured I can't use join as that is for seperate tables, right? Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 16, 2007 Share Posted January 16, 2007 Perhaps the people who are prohibiting you from posting it would have the solution ;) Quote Link to comment Share on other sites More sharing options...
rockinaway Posted January 16, 2007 Author Share Posted January 16, 2007 He gone.. not on and I need to figure this out.. can anyone help? Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted January 16, 2007 Share Posted January 16, 2007 Well can you post the error that you are getting and the lines of code that corrispond to the error? Quote Link to comment Share on other sites More sharing options...
dgiberson Posted January 16, 2007 Share Posted January 16, 2007 There's one of two things probably wrong, either the SQL statement or how the info is displaying to the screen. Please POST that section of code. 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.