Re: displaying categories/subcategories using modified preorder tree transversal

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@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • 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)
  • 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)
  • Help with SQL refrencing fields in same record
    ... swinventory.subcatID FROM (swsubcategory INNER JOIN swinventory ON ... I need to somehow reference the catID and the subcatID at the same time. ... The catID is needed to display all the subcatID menu items that are clicked ...
    (microsoft.public.sqlserver.mseq)
  • 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)