Re: select with parentID field into multidimensional array?

Im not putting the array data back intoi the db, it is just to structure the data coming out of the db before i create a tree like structure with it on the page The data going into the db will always be a simple ID name parentID. Its the neatest way to do it I can think of including using the array structure. I am imagining it is possible to implement a way to take a select * from table and format an array with all the data in a tree like structure within the array with one pass of the data, then on a single pass of the array write out the info in whatever tree like format i wish onto my page. If I work it out Ill be sure to post it :) On Sun, 21 Jan 2001 nuitari@darklands.cx wrote: > Date: Sun, 21 Jan 2001 15:50:16 -0500 > From: nuitari@darklands.cx > To: php-db@lists.php.net > Subject: Re: [PHP-DB] select with parentID field into multidimensional > array? > > Hi, > > Maybe it would be better not to use a multidimentionnal array in a db. > You should create to additionnal columns that stores the ParentID > of the row. > > It's the easiest way to do it. > > Also you can create another table that would translate from > numbers to text, or just put the text. > > > Stephen wrote: > > > > I am having most of my problems because I am trying to do this walking > > through the data a single time, with the assumption any records parentID > > has an ID less than the child and therefore would already be populated in > > the array... > > > > On Sun, 21 Jan 2001, Stephen wrote: > > > > > Date: Sun, 21 Jan 2001 23:49:13 +1100 (EST) > > > From: Stephen <stephen@tha.net> > > > To: php-db@lists.php.net > > > Subject: [PHP-DB] select with parentID field into multidimensional array? > > > > > > Hi > > > > > > I have a table which is set out like this > > > > > > ID name parentID > > > > > > I "select * from table" into $result. > > > > > > I then wish to walk through the result such that it creates a > > > multidimensional array sorted with children under parents. Here is a basic > > > eg. > > > > > > ID name parentID > > > 1 books 0 > > > 2 movies 0 > > > 3 songs 0 > > > 4 horror 1 > > > 5 love 1 > > > 6 horror 2 > > > 7 love 2 > > > 8 scifi 2 > > > 9 IT 4 > > > > > > etc > > > > > > I am trying to write a function that would then insert these into a > > > multidimensional array as such... > > > > > > $array[1] = "books"; > > > $arary[1][4] = "horror"; > > > $array[1][4][9] = "IT"; > > > > > > etc, so I could pull them out into a select dropdown list nicely sorted. > > > > > > I am not sure how to write an array function with an unlimited number of > > > levels. If someone could help out it would be greatly appreciated. > > > > > > Thanks > > > Stephen > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > email: meridian at tha net > > web: meridian.on.tha.net > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > email: meridian at tha net web: meridian.on.tha.net