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]

Reply via email to