Posted by Jerry Stuckle on 08/31/06 18:50

hornedw wrote:
> 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.
>
>

I guess I'm confused. How do you link from "fiction" or "nonfiction" to
books?

This way of doing it looks quite confusing to me.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]