Group By with headings for each section

**ChipJohns** · 03-25-2008, 04:08 PM

Okay, here is what I need/want to do...

Not only sort by group, I want to break it down to display in sections...

Displayed like this:

HTML Code:

Group1
  Item 1
  Item 2
  Item 3
 
Group2
  Item 4
  Item 5
  Item 6
 
Group 3
  Item 7
  Item 8
  Item 9
etc.

Can this be done with one server call? I believe I need to use GROUP BY but can't figure out how to make it work to display the info in sections like this.

any ideas..?

Thanks all,

Chip

**alex74** · 03-27-2008, 02:11 PM

Hmm I think you might be looking at this wrong.

You probably don't need to grab all the information within a single SQL query.

Show us the exact information you are looking to display like that, you should be able to do even 3 SQL queries to pull the info.

Also it's hard for us to give you code if we don't know the table names and fields.

**ChipJohns** · 03-27-2008, 03:17 PM

I know that I can do 3 seperate runs to the server for this, however, for this to be truly dynamic, for instance, what if I do not know what values are in the group field. At any given time there may be 3 or 7 or more vaules in this field. If I want to display all records for each of these values, it needs to be produced on the fly...

03-25-2008, 04:08 PM	#1 (permalink) Group By with headings for each section
ChipJohns I don't know! Do you? Posts: 477 Name: Chip Johns Location: Savannah Georgia Talkupation:	Okay, here is what I need/want to do... Not only sort by group, I want to break it down to display in sections... Displayed like this: HTML Code: Group1 Item 1 Item 2 Item 3 Group2 Item 4 Item 5 Item 6 Group 3 Item 7 Item 8 Item 9 etc. Can this be done with one server call? I believe I need to use GROUP BY but can't figure out how to make it work to display the info in sections like this. any ideas..? Thanks all, Chip

03-27-2008, 02:11 PM	#2 (permalink) Re: Group By with headings for each section
alex74 Junior Talker Posts: 2 Talkupation:	Hmm I think you might be looking at this wrong. You probably don't need to grab all the information within a single SQL query. Show us the exact information you are looking to display like that, you should be able to do even 3 SQL queries to pull the info. Also it's hard for us to give you code if we don't know the table names and fields. __________________ Colonix Reviews and articles. The Almighty Cleanse review. Dual Action Colon Cleanse reviews.

03-27-2008, 03:17 PM	#3 (permalink) Re: Group By with headings for each section
ChipJohns I don't know! Do you? Posts: 477 Name: Chip Johns Location: Savannah Georgia Talkupation:	I know that I can do 3 seperate runs to the server for this, however, for this to be truly dynamic, for instance, what if I do not know what values are in the group field. At any given time there may be 3 or 7 or more vaules in this field. If I want to display all records for each of these values, it needs to be produced on the fly...