unlimited category tree

[mohamedbadr]

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 ;

 

 

[dawsba]

Please explain in more detail???