Showing groups in php webshop

Hi guys,

I’ve created with the help of kirupa’s forum small web shop.
I can let the php show the products in a grid, i can let show php every product but i can’t let php show me the groups and subgroups.

First i will explain how the database is set up:
The database “products” has a table “articles”.
In this table i have about 10 fields but the most important fields are like in the example[LIST]
[]id (0001)
[
]maingroup (phones, accessoires, gadgets)
[]group (mobilephones, phones, wired phones)
[
]subgroup (smartphone, pocketphone)
[]brand (nokia, lg, samsung)
[
]type (E50, E65)[/LIST]I have an index page. On this page i will hardcode 3 links to the maingroups (phones, accessoires and gadgets)

[COLOR=Navy] When i click on the link “phones” i would like to view al of the groups that are under the maingroup “phones”.[/COLOR][LIST]
[][COLOR=Navy]mobilephones[/COLOR]
[
][COLOR=Navy]phones[/COLOR]
[][COLOR=Navy]wired phones[/COLOR][/LIST][COLOR=Navy]When i click on “mobilephones” i would like to see a list like[/COLOR][LIST]
[
][COLOR=Navy]smartphone[/COLOR]
[*][COLOR=Navy]pocketphone[/COLOR][/LIST]And when i click on “smartphone” then i go to the grid “subprod.php?detail=smartphone” with al the smartphones, this grid i have.

The problem i have is the stuff in blue, its only this step that i’m missing. It’s a kind complicated i think but i did my best to explain it as good as possible