FUDforum: comp.lang.php » Loop through array, change headings

Home » Imported messages » comp.lang.php » Loop through array, change headings

Show: Today's Messages :: Polls :: Message Navigator

Loop through array, change headings [message #184432]

Tue, 31 December 2013 21:08

Adrienne Boswell
Messages: 25
Registered: October 2010

Karma:

Junior Member

I'm sure this has been asked and answered, but I am either too stupid to
figure out the right way to ask Google, or I'm lazy, or it really hasn't
been asked. Sorry in advance, and if it has been answered, please refer
me as needed.

Here's my situation:
I have a table that has three classifications:
id Classification
1 Stores
2 Restaurants
3 Services

I have another table that has categories in each classification, eg.
id Category Classification_id
1 Market 1
2 Pet Shop 1
3 Pizza 2
4 Sandwich 2
5 Notary 3
6 Repair 3

My query is
SELECT c.id, category, classification, cl.id AS classid FROM category
c JOIN classification cl ON c.classification_id = cl.id ORDER BY classid,
category

What I want to do is:
-Stores
Market
Pet Shop
-Restaurants
Pizza
Sandwich
-Services
Notary
Repair

So, as I'm looping through my recordset, if the classid has changed, I
want to change the header. I don't want to make one query to get the
headings, and then do another query for each classid. I KNOW there has
got to be a better way.

I'm trying to get this all done so I can have a Happy New Year, and
wishing you and yours a Happy New Year as well.

--
Adrienne Boswell
Arbpen Web Site Design Services - http://www.cavalcade-of-coding.info/
The Good Plate - Fresh Gourmet Recipes - http://the-good-plate.com/
Please respond to the group so others can share

Report message to a moderator

[Message index]

		Loop through array, change headings By: Adrienne Boswell on Tue, 31 December 2013 21:08
		Re: Loop through array, change headings By: Denis McMahon on Tue, 31 December 2013 21:22
		Re: Loop through array, change headings By: Adrienne Boswell on Tue, 31 December 2013 23:40
		Re: Loop through array, change headings By: Mr Oldies on Tue, 31 December 2013 22:06
		Re: Loop through array, change headings By: Denis McMahon on Tue, 31 December 2013 23:00
		Re: Loop through array, change headings By: Mr Oldies on Wed, 01 January 2014 00:19
		Re: Loop through array, change headings By: Denis McMahon on Wed, 01 January 2014 00:39
		Re: Loop through array, change headings By: Beauregard T. Shagnas on Wed, 01 January 2014 00:56
		Re: Loop through array, change headings By: Jerry Stuckle on Wed, 01 January 2014 01:50
		Re: Loop through array, change headings By: Mr Oldies on Wed, 01 January 2014 02:08
		Re: Loop through array, change headings By: Jerry Stuckle on Wed, 01 January 2014 02:43
		Re: Loop through array, change headings By: Beauregard T. Shagnas on Wed, 01 January 2014 03:24
		Re: Loop through array, change headings By: Denis McMahon on Wed, 01 January 2014 03:26
		Re: Loop through array, change headings By: Arno Welzel on Wed, 01 January 2014 17:01
		Re: Loop through array, change headings By: Norman Peelman on Thu, 02 January 2014 11:23
		Re: Loop through array, change headings By: Denis McMahon on Thu, 02 January 2014 13:09
		Re: Loop through array, change headings By: Peter H. Coffin on Thu, 02 January 2014 15:20
		Re: Loop through array, change headings By: Beauregard T. Shagnas on Thu, 02 January 2014 15:39
		Re: Loop through array, change headings By: Jerry Stuckle on Thu, 02 January 2014 15:52
		Re: Loop through array, change headings By: Beauregard T. Shagnas on Thu, 02 January 2014 16:43
		Re: Loop through array, change headings By: Peter H. Coffin on Mon, 06 January 2014 00:23
		Re: Loop through array, change headings By: Peter H. Coffin on Mon, 06 January 2014 00:37
		Re: Loop through array, change headings By: Denis McMahon on Thu, 02 January 2014 18:04
		Re: Loop through array, change headings By: Arno Welzel on Wed, 01 January 2014 16:56

Previous Topic:	thank you, richard@noreply
Next Topic:	PHP sql entry is a godaweful mess

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:43:18 GMT 2024

Total time taken to generate the page: 0.05190 seconds