Re: array recursion from database rows

On 5/24/08, Bob <phpnews@opensauce.com> wrote: > > Hi. > > I have a database table I have created for navigation. > > The table fields are uid, parent_id, menu_name. > > Each entry is either a top level element with a parent_id of 0 or a child > which has a parent_id that relates to the parent uid. > > What I am trying to do is recurse through a set of rows adding the > child(ren) of a parent to a multi-dimensional array. > > Does anyone know how I can do this, I've tried (unsuccessfully) to traverse > the rows to create this array but I keep failing miserably. > > This is probably very easy for the people on this list so I am hoping > someone could help me out. > > Thanks in advance. > > Cheers. > > Bob if you order your result set by record id and parent id then your set should be much easier to loop thru, when you hit an empty parent id field its a new parent and you could use the row id (or whaever) as the key and then keep adding the children until you hit a new (empty) parent id -- > > Bastien > > Cat, the other other white meat