i want to display all users which are below my status.
the lead_id shows my id if i m the manager. all users when registering will have to put the person in charge id(lead-id) but in my case, i m getting only users with my id.
e.g
id name leadid
1 xxx 0
2 aa 1
3 sdd 1
4 fdfs 2
5 fdss s 2
6 fdgd 3
7 erte 4
8 ewr 4
9 fsdrt 4
10 ytr 5
id 1 can view all users
id 2 can view user 4 5 7 8 9 10
id 3 can view 6
id 4 can view 7 8 9
i wish to display all users for each a manager is associated.. for e.g an hr manager needs to gets all his staff regarding hr, but i cant process it
i ve 3 table with 1 user providing user info and 1 for dept_user and 1 for department. the dept_user table consists of user_id, dept_id, lead_id and role. when a user register, he needs to put lead_id which is for the user in charge of the person registering and the role specifies either staff manager or team leader.. A manager can view all the the teamleaders and the users associated with the teamleader.
manager for role 3 and team leader for role2
//get userid from login session $memberid = $_SESSION[ SESS_MEMBER_ID ]; //get role from session $role = $_SESSION[ SESS_ROLE_ID ] while($res = mysql_fetch_array($role)){ if($role== 3 ){ $teamleader = mysql_query("select userid from dept_user where lead_id= $member_id "); while ($data = mysql_fetch_assoc($teamleader)) { $user = mysql_query("select firstname, lastname, email from user where userid in(select userid from dept_user where lead_id=$data)"); $result = mysql_query($user); print $result; } } else if ($role== 2 ){ $user = mysql_query("select firstname, lastname, email from user where userid in(select userid from dept_user where lead_id= $member_id "); print $user; } }