This is probably obvious and simple - but it isn't to me :)
item_id ¦ item_name ¦ item_describtion ¦ more item stuff.....
subitem_id ¦ item_id ¦ subitem_name ¦ More subitem stuff
Each item can have zero to pretty much unlimited subitems, and are related by the fields item_id.
I want to print out the subitems grouped by item.
I am currently doing this with a query which selects subitems where table_items.item_id = table_subitems.item_id. Which is fine as far as it goes, I get something like this:
Item One - Subitem 0ne
Item One - Subitem two
Item One - Subitem three
Item Two - Subitem one
Item Three - Subitem one
Item Three - Subitem two
But I want
How do I do this? Is it a function of the query or of how I show the results?