Re: Re: Adding all extensions to bugs.php

Addressed to: Bug Database <php-dev@lists.php.net> php-qa@lists.php.net ** Reply to note from Jani Taskinen <sniper@iki.fi> Sun, 3 Sep 2000 23:18:24 +0300 (EEST) > > > >Database Related > > -MySQL Related > > -mSQL Related > >Catagory 2 Related > > -Sub Cat 1 > > > > This is better than having multiple select boxes which would just be more > complex. > I have a function that creates indented select boxes from a MySQL table, I also have a PHP page that edits the table and enforces valid parent values to prevent loops in the parent link. If you want it just let me know... CREATE TABLE Selections( ID bigint not null auto_increment, Parent bigint, Description, PRIMARY KEY( ID )); ID Parent Description 1 0 One 2 0 Two 3 0 Three 4 1 One A 5 1 One B 6 4 One A A 7 2 Two A Results in One -One A --One A A -One B Two -Two A Three There is no built in limit to the depth you can nest things. Rick Widmer Internet Marketing Specialists http://www.developersdesk.com