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? Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/ 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 Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162277 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? Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162278 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 ;) Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162280 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? Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162282 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? Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162287 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. Link to comment https://forums.phpfreaks.com/topic/34462-php-and-mysql-help/#findComment-162333 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.