Posted by Frank on 09/29/74 11:33

I have a mySql db 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 create labels in order to present the
user with the data in the following structure:

Main Category
Category
Sub Category
answer1
answer2
answer3
...

Main Category
Category
Etc...

I could really use some help on a query to group the data in this way!

Thanks in advance!!!


Frank

• Next in forum: Re: help with query and presentation...
• Prev in forum: Re: number of entries in a date column
• Thread view: help with query and presentation...

[Reply to this message]