PHP Nested Loops

[AceTutor_Warwick]

Greetings - am a absolute newbie to PHP/MySQL and would appreciate kickstart help

I have attempted tutorial at DMX Zone but failed without success.
See http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=4937

Basic Setup:

Database: MySQL
id Name
0 Fruit
1 Banana
1 Pineapple
1 Kiwi Fruit
1 Apples
0 Vegetable
6 Tomatoes
6 Peas
6 Carrots


Output required:
Fruit
Apples
Banana
Kiwi Fruit
Pineapple
Vegetable
Carrots
Peas
Tomatoes

Requirement:
Depending on designated id, all items starting with 0 become bold category headings listed in alphbetical order and all associated products matching that category would be listed - also in alphabetical order.

A working code sample - or suggested tutorial sites would be greatfully received

Thanks in anticipation

Bless ya heaps

AceTutor

[TheBluffs]

I don't know anything about php which is why I buy some scripts from Interaktonline.com, they're great and have wonderful customer service.

For the few bucks it'll cost you it might be worth it.

[Newsgroup_User]

Tom Muck has an extension that will allow you to achieve what you want from
a standard DW recordset
http://www.tom-muck.com/extensions/help/simulatednestedregion/

--
Dave Buchholz
I-CRE8
www.i-cre8.co.uk


"AceTutor@Warwick" <webforumsuser@macromedia.com> wrote in message
news:e50gnm$4cm$1@forums.macromedia.com...
Greetings - am a absolute newbie to PHP/MySQL and would appreciate kickstart
help

I have attempted tutorial at DMX Zone but failed without success.
See <a target=_blank class=ftalternatingbarlinklarge
href=" http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=4937">http://www.dmx
zone.com/showDetail.asp?TypeId=2&NewsId=4937</a>

Basic Setup:

Database: MySQL
id Name
0 Fruit
1 Banana
1 Pineapple
1 Kiwi Fruit
1 Apples
0 Vegetable
6 Tomatoes
6 Peas
6 Carrots


Output required:
<b>Fruit</b>
Apples
Banana
Kiwi Fruit
Pineapple
<b>Vegetable</b>
Carrots
Peas
Tomatoes

Requirement:
Depending on designated id, all items starting with 0 become bold category
headings listed in alphbetical order and all associated products matching
that
category would be listed - also in alphabetical order.

A working code sample - or suggested tutorial sites would be greatfully
received

Thanks in anticipation

Bless ya heaps

AceTutor

[AceTutor_Warwick]

Thanks Dave for your suggestion.

I have tried to use Tom's extension but what I forgot to reveal in my original post is that I am using Dreamweaver 8.0.2.

After installing his extension I could not discover where the appropriate command was invoked and it was my conclusion that it was developed for UltraDev (that's what tutorial suggested) and would not run on DW8. Maybe I had a bad install. Maybe you could confirm that!

As for whenharry's comment - I will investigate. Thanks

In meantime I would still appreciate if you / or someone else could direct me with a working solution. For me - both the DMXZone and Toms Mucks extension have proposed an answer but to state the obvious - I'm not there yet.

Again thanks for any help provided.

AceTutor

[Newsgroup_User · Accepted solution]

> After installing his extension I could not discover where the appropriate
> command was invoked and it was my conclusion that it was developed for
> UltraDev
> (that's what tutorial suggested) and would not run on DW8. Maybe I had a
> bad
> install. Maybe you could confirm that!

Server Behaviors > DWTeam > Simulated Nested Region

If all else fails, check the description in the Extension Manager. It
usually shows where the menu for a particular extension is.

It works fine in DW 8.


--
--
Tom Muck
co-author Dreamweaver MX 2004: The Complete Reference
http://www.tom-muck.com/

Cartweaver Development Team
http://www.cartweaver.com

Extending Knowledge Daily
http://www.communitymx.com/

[AceTutor_Warwick]

Thanks for help