posted 19 years ago
Hi all,
I want to display multitier data in one page,
e.g. I have familyID, addressID, and familyMember
each addressID has several familyMembers and each familyID has several addressIDs, and I want to show them as multitier structure like the following:
SearchResult:
familyID1
addressID1
David....
YUlina
addressID2
Frank...
Steve
FamilyID2
addressID3
Tom
addressID4
Senthil
FamilyID3
.....
And I can use one select to get all data from database
.e.g. select familyID, addressID, familyMember from table
Could anyone give me any idea about it?
THanks so much,