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

RE: Recursive select to produce hierarchical listing

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 Menu AS M2

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

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

RE: recursive select

]; getCategories($res[child],$array); } return; } ? -Original 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

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 to

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. Dhir wrote: Ah recursion. Nothing like

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

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

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 Where emp.

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