On Thu, 2007-12-27 at 04:48 +0000, suppressed 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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.