PHP MySQL Question

[shannonlp]

Site: Craft Cruises – Group Cruises‚ Knitting retreats‚ Women’s Travel and more

I am trying access information from 3 tables. Table 1 is brand information, table 2 is product information, table 3 is an intersection table holding the ID's of tables 1 and 2 and a primary key.

I have created a query that will retrieve the information as follows:

col1: brand ID
col2: brand name
col3: product name

The problem I have is that I am trying to populate a menu seen on the left with the information retrieved.

I want to get the brand name in the primary link and if a product exist associated to the brand the create the sub links until all links are created.

I need to change the information from the result array to eliminate duplicate brands and loop through the sub links without duplication.

I am sure this is clear as mud. Any help would be appreciated.