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
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
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
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
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 land in... Like so:
> -Original M
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
>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
