Well don't forget to use the order by and group by and where commands in SQL they could be quite useful in making a tree Stephen wrote: > > 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 [EMAIL PROTECTED] wrote: > > > Date: Sun, 21 Jan 2001 15:50:16 -0500 > > From: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> > > > > To: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > email: meridian at tha net > > > web: meridian.on.tha.net > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > email: meridian at tha net > web: meridian.on.tha.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
