# Showing groups in php webshop

**URL:** <https://forum.kirupa.com/t/showing-groups-in-php-webshop/235154>\
**Category:** programming\
**Created:** [August 8, 2007, 9:42pm UTC](https://forum.kirupa.com/t/showing-groups-in-php-webshop/235154 "2007-08-08T21:42:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![stedem](https://avatars.discourse-cdn.com/v4/letter/s/7c8e57/32.png) [@stedem](https://forum.kirupa.com/u/stedem)\
**Post date:** [August 8, 2007, 9:42pm UTC](https://forum.kirupa.com/t/showing-groups-in-php-webshop/235154/1 "2007-08-08T21:42:08Z")

</div>

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
