Insert New Field Into

[Manat]

Hello all

My product Catalog is not well organised.  There are huge Categories with too many sub-categories.  And customers are more familiar with sub categories rather than parent categories.

But our online catalog only lets you search by parent categories.   So, basically I have two questions.

First, in order to fix this DB design issue(MySQL), I would like to add another field into our products table, so that all subcategories are listed as subcategories.    Like perhaps, Sub-Category = attr.

So, when I click on a link, it lists all products that has a sub-category of attr. That would fix the catalog problem. My question is, how would I do this?

Can someone give me a snippet of code that would add the SubCat Field to an already existing table, that allows NULLS. I would do this through PHPmyAdmin.

Also, my second question is, would this be the right direction to take to fix the catalog problem?

Thanks to all
MK

[PHPdev]

Well this should be easy...

the code goes something like this...

Alter table "tablename" add "field attrib"

ALTER TABLE products add subcat int;

but since you are running MyPHPAdmin you should be able to look at the structure of the table by clicking on it in the Left hand Colum... and then at the bottom there is a section that says...

Add new field: number entry... drop down

that will allow you to add a new field to an existing table too

LMK if this works...

PHPdev