|
|
Posted by hornedw on 09/01/06 02:28
Jerry
I was trying to set it up where when a person clicks on books the page
would reload and then display Books and then Nonfiction and Fiction
would appear under it. Like below
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)
It does not necessaryly have to be spaced over. I may use bulleted list
or something like that. The main two things I was trying to do was use
the modfied preorder tree algorithm and to have it display the main
category and then display the main category and its subcategories and
then the rest of the categories on the page. I was debating on whether
doing it this way or something similar to the way it is done at
Amazon.com on their categories.
David
Jerry Stuckle wrote:
> 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
> ==================
Navigation:
[Reply to this message]
|