help auto populating multiple drop downs.

[jbrill]

k one last question..this:

 

$sel->addSelect('category', 'category', 'cat', 'category','',1,'--Category--');

$sel->addSelect('subcat', 'subcategory', 'subc', 'subcat','cat',1,'--Sub_category--');

 

a) is only putting in the subcategory into the database

b) its putting in the subcat ID not the name of the item

 

whats the problem?

[Barand]

That's usually what is required in a normalised db.

 

If you know the subcat id, then, by joining table you can get the category.

 

Id's are usually stored and not the name.