|
Posted by Frank on 12/05/05 03:54
I have a table with the following structure:
main_category| category| sub_category| answer|date
Basically, the data will be along these lines:
Neuro | LOC | Status | answer1|date
Neuro | LOC | Status | answer2|date
Neuro | LOC | Status | answer3|date
Senso| Visi | Clarity | answer1|date
Senso| Visi | Clarity | answer2|date
etc...
I am trying to query the db and present the user with the data in the
following structure:
Main Category
Category
Sub Category
answer1
answer2
answer3
...
Main Category
Category
Etc...
There are literally 3 dozen main categories, categories, and
sub-categories each with distinct answers.
I could really use some help on a query to group the data in this way!
Thanks in advance!!!
Frank
Navigation:
[Reply to this message]
|