|
|
Posted by hornedw on 08/30/06 18:54
the category table should look like the following. it did not display
very well in the first message
catid, name,lft,rgt
1, home,1,1
2, books,2,17
4, fiction,3,10
5, nonfiction, 11,16
3, electronics,18, 37
hornedw wrote:
> I have been working on a ecommerce website for myself. What I needed
> some assistance on was when i was trying to display the
> categories/subcategories for the different products.
> I decided to use the modified preorder tree transversal algorithm. What
> I wanted was on the first page is to display the catogories as follows
>
> Books (35)
> Electronics(23)
>
> The number inside the parenthesis being the number of products in that
> category. When Books is clicked on, it would display the following
>
> Books(35)
> Fiction(18)
> Nonfiction(17)
> Electronics(23)
>
> In my MYSQL database table, I have the fields catid, name, lft and
> rgt. For example for the three categories mentioned above I have the
> following entries
>
> catid name lft rgt
> 1 home 1 1
> 2 books 2 17
> 4 fiction 3 10
> 5 nonfiction 11 16
> 3 electronics 18 37
>
>
> The first category home was just used to represent the main root of the
> whole tree. If anyone could give me some assistance, it would be much
> appreciated. Thank you in advance.
Navigation:
[Reply to this message]
|