I have a category structure like this...
Many of you have done this sort of thing in different RAD languages.. currently I use a query to for each parent category to get the child categories.. (lots and lots of queries)...
Is there anyway to do it with one? So that I can conform the output to something like..
Any ideas anyone? I mean.. Attempts I take at this loop the server way too many times and I still haven't gotten anything like the results I want...
Tony ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
Code:
ID Name Parent
1 Home 0
2 CPU 1
3 Intel 2
4 Memory 1
5 AMD 2
6 SDRAM 4
Many of you have done this sort of thing in different RAD languages.. currently I use a query to for each parent category to get the child categories.. (lots and lots of queries)...
Is there anyway to do it with one? So that I can conform the output to something like..
Code:
Home
CPU
Intel
AMD
Memory
SDRAM
Any ideas anyone? I mean.. Attempts I take at this loop the server way too many times and I still haven't gotten anything like the results I want...
Tony ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.