Re: recursion or something recursion-esque

2007-09-24 Thread Peter Brawley
Mike, >What I'd love to do is pull all children (and grandchildren, etc) per >each, such that I'd end up with the following result set or something See http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html for theory & examples. PB Mike Johnson wrote: This one may end up dead in

recursion or something recursion-esque

2007-09-24 Thread Mike Johnson
This one may end up dead in the water, but I figured I'd run it past the group as I've seen some pretty creative solutions in my time here. Let's say I have a table like this: ++---+ | id | parent_id | ++---+ | 1 | 0 | | 2 | 0 | | 3 | 2 | | 4 |