MainCategory and Subcategories Product Display Problem

[DigiWolf]

Dear all,

I am experiencing a complicated problem regarding product display in a page of
an e-commerce website. The situation is as follows: there are two tables: one
hosts the categories and the subcategories of the products and the other one
hosts the products. The table 1 contain a field, which is called "CatFatherID"
amongs others. This particular field differentiates the main categories with
the subcategories like this: when CatFieldID is 0, then the category is a main
category. When it contains a number, then this category is a subcategory of a
maincategory with the corresponding ID. The Product Table contains the products
with CatID the catID of the subvcategories.

What I would like to do is to find a way to display all the products of the
main category (that belong to its subcategories).

I find it difficult. Could you please help me?

Thank you in advance,

Lazaro

[Paul Whitham TMM]

Lazaro

If the data is in several tables then you will need to create a SQL join to
bring them together. The simplest way to do this is in the database itself.
If you are using Access then simply create a query and add the tables. Then
use this query as the source for your recordset on the page.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"DigiWolf" <webforumsuser@macromedia.com> wrote in message
news:d5vuvl$750$1@forums.macromedia.com...

> Dear all,
>
> I am experiencing a complicated problem regarding product display in a

page of

> an e-commerce website. The situation is as follows: there are two tables:

one

> hosts the categories and the subcategories of the products and the other

one

> hosts the products. The table 1 contain a field, which is called

"CatFatherID"

> amongs others. This particular field differentiates the main categories

with

> the subcategories like this: when CatFieldID is 0, then the category is a

main

> category. When it contains a number, then this category is a subcategory

of a

> maincategory with the corresponding ID. The Product Table contains the

products

> with CatID the catID of the subvcategories.
>
> What I would like to do is to find a way to display all the products of

the

> main category (that belong to its subcategories).
>
> I find it difficult. Could you please help me?
>
> Thank you in advance,
>
> Lazaro
>

[DigiWolf]

Unfortunately, I have tried to join the tables but it seems to be very diffuclt for me. Could anyone please help me? I have provide the complete table structure if needed. Thank you in advance.