RE: Recursive select to produce hierarchical listing

jamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 2:43 PM To: Michael Collins Cc: [EMAIL PROTECTED] Subject: Re: Recursive select to produce hierarchical listing Hi. Maybe I am missing something, but won't SELECT M1.*,M2.* FROM Menu AS M1 JOIN Men

Re: Recursive select to produce hierarchical listing

Hi. Maybe I am missing something, but won't SELECT M1.*,M2.* FROM Menu AS M1 JOIN Menu AS M2 ON M1.ID = M2.ParentID WHEREID=0 ORDER BY M1.Index, M2.Index work? Bye, Benjamin. On Tue, Nov 20, 2001 at 06:04:11PM -0800, [EMAIL PROTECTED] wrote: > I am trying to displ

Recursive select to produce hierarchical listing

I am trying to display a hierarchically related list of folders via a recursive SQL statement (each row in a table represents a folder). What is needed is a select that will sort the folders and associate the parent folder with their child, sub-folders. The kicker is that the items in the fold

Recursive select to produce hierarchical listing

I am trying to display a hierarchically related list of folders via a recursive SQL statement (each row in a table represents a folder). What is needed is a select that will sort the folders and associate the parent folder with their child, sub-folders. The kicker is that the items in the fold

RE: recursive select

Good catch :) > -Original Message- > From: Don Read [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 6:44 AM > To: Alok K. Dhir > Cc: [EMAIL PROTECTED]; Chih-Lii Chen/Trans-EZ/TW > Subject: RE: recursive select > > > > On 13-Jun-01 Alok K

RE: recursive select

On 13-Jun-01 Alok K. Dhir wrote: > Ah recursion. Nothing like it to get your mind tied up in knots... :) > > Try this - untested, but this is the basic idea, and it or something > like it should work. Call the function with the node you want to start > from and the array you want the results t

RE: recursive select

nal Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > m] On Behalf Of Chih-Lii Chen/Trans-EZ/TW > Sent: Tuesday, June 12, 2001 9:24 PM > To: [EMAIL PROTECTED] > Subject: recursive select > > > Hi, > > I'm having a slight problem trying to

Re: recursive select

Hi, > I'm having a slight problem trying to figure out some logic. I have a > mySQL table that contains 3 columns (child, category, parent). > What I like to do is retrieve all the childrens of the parent and store > them in an php array. I assume you want to get all children for all parents (so

recursive select

Hi, I'm having a slight problem trying to figure out some logic. I have a mySQL table that contains 3 columns (child, category, parent). What I like to do is retrieve all the childrens of the parent and store them in an php array. Any advies on this issue will be very helpful. Thanks in adva

Re: recursive select

>Dear, > I have an table which like to use recursive join but I wonder >how to use it. Please see the table struc below. > emp.id,emp name, emp salary, emp head-id > 001,mr. a,1,001 > 002,mr. b,5000,001 > 003,mr. c,5000,003 > 004,mr. d,5000,003 > Whe

recursive select

Dear, I have an table which like to use recursive join but I wonder how to use it. Please see the table struc below. emp.id,emp name, emp salary, emp head-id 001,mr. a,1,001 002,mr. b,5000,001 003,mr. c,5000,003 004,mr. d,5000,003 Where