Anzeo Posted April 14, 2007 Author Share Posted April 14, 2007 Hmm okay so now I got the output working again, the only problem remaining now is my initial problem on how to show the resulting output as NEWS General Site CATEGORIE2 Forum2.1 Forum2.2 etc. Do you know how to do this? Because I'm only using one qry now but it dosn't seem to be fetching all categories... Quote Link to comment Share on other sites More sharing options...
Anzeo Posted April 14, 2007 Author Share Posted April 14, 2007 Is it possible that I need two querries for that? Because I can't seem to get them grouped together by category? Quote Link to comment Share on other sites More sharing options...
Glyde Posted April 14, 2007 Share Posted April 14, 2007 Try: SELECT * FROM CATEGORIE RIGHT JOIN FORUM ON FORUM.Categorie=CATEGORIE.ID GROUP BY CATEGORIE.ID ORDER BY CATEGORIE.VolgNr I'm not entirely sure what that'll produce. Quote Link to comment Share on other sites More sharing options...
Anzeo Posted April 14, 2007 Author Share Posted April 14, 2007 Hmm doesn't seem to work. You can check the output here It should give something like: Nieuws Algemeen nieuws "description" site "description" netwerk "description" Rapporten Bugs "description" Quote Link to comment Share on other sites More sharing options...
Anzeo Posted April 16, 2007 Author Share Posted April 16, 2007 Does anyone know how to do this? Quote Link to comment Share on other sites More sharing options...
Anzeo Posted April 17, 2007 Author Share Posted April 17, 2007 UPDATE: I can use the code as I showed in the first post of this topic when I'm using diffrent variables for both queries I think, shoudn't that solve the problem? 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.