Re: displaying categories/subcategories using modified preorder tree transversal

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.

.

Relevant Pages

  • applications in Add/Remove Programs list are missing
    ... Thanks in advance for assistance, ... I click on the Control Panel and then Add or Remove Programs, ... programs that DO have the on/off switches to display the programs seem to be ... Korner site at http://www.kellys-korner-xp.com/xp_tweaks.htm? ...
    (microsoft.public.windowsxp.configuration_manage)
  • Re: Insert formula
    ... Thanks for the assistance guys, ... Both'em display the following message error: ... "Run-time error '1004': ...
    (microsoft.public.excel.programming)
  • Re: displaying categories/subcategories using modified preorder tree transversal
    ... hornedw wrote: ... catid, name,lft,rgt ... I wanted was on the first page is to display the catogories as follows ... If anyone could give me some assistance, ...
    (comp.lang.php)
  • displaying categories/subcategories using modified preorder tree transversal
    ... I decided to use the modified preorder tree transversal algorithm. ... I wanted was on the first page is to display the catogories as follows ... When Books is clicked on, ... If anyone could give me some assistance, ...
    (comp.lang.php)
  • My Schedule: Am I dreaming?
    ... assistance, they need as much information as possible. ... they need to count all the times a class occurs to date and display the ... count in a cell for a given day on a given period. ... because a schedule change may shift that class to another day or period. ...
    (microsoft.public.excel.misc)