I have categories table with multilevel categories I need to
make the insert statement for the sub categories and sub subcategories so I need
to populate a <select> box with this tree so I can insert the parent id
with the new subcategory
Anyone knows how to populate this select box with the tree ??
The table is here
CREATE TABLE IF NOT EXISTS `hosp_categories` (
`category_id` int(10) NOT NULL auto_increment,
`parent_id` int(10) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;