well.. all i can say is in page.cgi the home won't display categories.. cause you mispelled: CategoryHeiarchy
change
SELECT c.*
FROM CategoryHierarchy AS h, Category AS c
WHERE h.CategoryID = 0 AND h.SubCategoryID = c.ID
!);
to
SELECT c.*
FROM CategoryHeirarchy AS h, Category AS c
WHERE h.CategoryID = 0 AND h.SubCategoryID = c.ID
!);
i've been mispelling heirarchy since the first time i used it too why can't it be like.. categoryTREE
jerry
change
Code:
$sth = $LINKDB->prepare (qq! SELECT c.*
FROM CategoryHierarchy AS h, Category AS c
WHERE h.CategoryID = 0 AND h.SubCategoryID = c.ID
!);
to
Code:
$sth = $LINKDB->prepare (qq! SELECT c.*
FROM CategoryHeirarchy AS h, Category AS c
WHERE h.CategoryID = 0 AND h.SubCategoryID = c.ID
!);
i've been mispelling heirarchy since the first time i used it too why can't it be like.. categoryTREE
jerry