[ic] new web site

Rick Bragg lists at gmnet.net
Thu Dec 27 15:47:20 EST 2007


On Thu, 2007-12-27 at 04:48 +0000, hudsondarnell40 at comcast.net wrote:
> i am building a site for a client. I want to know how to build
> category pages that has the products under that category. An so
> when the client puts new products up it goes into that category.


The way I did it was to make a table called "categories" then I added a
field in the products table called "categorycode"  This field points to
the key in the categories table.  I also added a field in the categories
table called "parentcode". This way, categories can have subcategories.
I had made lots of changes to results_buylist, flypage.html, and other
areas...  I also made a link in the admin area to "freeze" the left menu
with a custom "timed build"... I also added a flypage just for the
categories table that flies out the details of each category.  lots of
changes to make it work, but is is well worth it.  This allowed me to
get rid of the "prod_group" and "category" fields in the products table
as these lead to de-normalization and limitations... 

rick





More information about the interchange-users mailing list