[eluser]wizzer[/eluser]
Hello,
Is there a neat way to do this using CI framework?
I have 3 mysql tables.
my SQL results are like this after left joining tables.
section1 - category1 - type1
section1 - category1 - type2
section1 - category2 - type3
so the section is the primary key of table it has a one to many relationship, ie you can have 1 section to many categories and 1 type to many categories.
Im lost as to how to output this so i can have my results like
section1 - category1 - type1
type2(should be underneath type 1 but it wont stay!)
section1 - category2 - type3
I have been using PHP a while but amazingly never come across this, i think its common.
Can i do this in CI some way or will it be some messy function and I have toplay with arrays and checking for duplicates?
THANKS