>How can I do some recursion to get the UIDs of all the employees
>reporting up to a manager, regardless of how deep the tree is. I can
>do this usindg LDAP and/or PHP, but not sure how to do it as a mysql
>query.
Examples & discussion at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-----
Ali, Saqib wrote:
> Hello,
>
> I have following simplistic DB representing a hierarchy:
>
> +------------+----------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+----------+------+-----+---------+-------+
> | uid | int(10) | NO | PRI | 0 | |
> | name | char(80) | YES | | NULL | |
> | mail | char(80) | YES | | NULL | |
> | manageruid | int(10) | YES | | NULL | |
> +------------+----------+------+-----+---------+-------+
>
> How can I do some recursion to get the UIDs of all the employees
> reporting up to a manager, regardless of how deep the tree is. I can
> do this usindg LDAP and/or PHP, but not sure how to do it as a mysql
> query.
>
> Any thoughts? Thanks
>
> saqib
> http://www.capital-punishment.us
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.0.237 / Virus Database: 270.11.9/1993 - Release Date: 03/10/09 07:19:00
>
>
