Nested Categories Dropdownlist

Hi,

I have a categories table

cat_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

parent_id INTEGER NOT NULL DEFAULT 0,

name VARCHAR(50) NOT NULL DEFAULT ‘’

it has multi levels can be 3 4 or 5 …etc

i want to create a cascading dropdownlist for this table and having the last

dropdownlist having the id = Company[cat_id]

so i can save it into Company model.

can you help me pls on that ?

Best Regards

it’s typical treeview, you may want to look at that direction. in native yii or extension.