I have a employee table that includes there username and the username of there manager.
In one section of the site i need to be able to grant access to only people within certain chains. for example
at the moment when a user is logged on i do an sql call that says select * from ... where line_man_id = session (myId) that will then find all my staff.
i need to take this one step futher and work out who is there staff if any. for example i am incharge of robert and andrew, and andrew is in change of craig and pete.
I need to see all the data for all these people, andrew needs to see data for craig and pete and so on.....
Any Help, much appreciated..