displaying categories/subcategories using modified preorder tree transversal

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: displaying categories/subcategories using modified preorder tree transversal
    ... catid, name,lft,rgt ... some assistance on was when i was trying to display the ... When Books is clicked on, ... If anyone could give me some assistance, ...
    (comp.lang.php)
  • 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)
  • 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)