Hi
Im making sort of a directory on my site.
Now I would need some advise how to build my DB ( access + asp ) for categories / subcategories.
Momentarily I have 2 tables.
First one
TBLPRODUCTS is for products
second
TBLCATS include Categories + Sub Cateogries.
On my page everything works well, expect when I want to count records
(#) next to cateogries I always get 0 or it shows all:
expample:
Category1
(4)
.....Subcateogry
(4)
Category2
(4)
.....Subcateogry
(4)
...and I only have 4 products in my product table.
Can any1 give me some advise on how to make my DB (categories / subcategories) so that users will be to see next to categories
( #) and when they click on certian cateogry it will show
Subcategories with correct
(#).
I hope u know what I mean....sorry for my poor english
Thanks,
Topic Options
Post Options
Thanks(0)
