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 |
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
