0){ while($row = mysqli_fetch_array($qEmp)){ $myCompID = $row['comp_id']; $myDealID = $row['branch_id']; $myPosID = $row['position']; $role = $row['access_role']; $accSta = $row['account_status']; if($accSta==0){ $textColor = '#A09E9E'; }else{ $textColor = '#494A4B'; } ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>

ID	EMP. ID	EMPLOYEE NAME	COMPANY	POSITION	CURRENT ACCESS
".$row['emp_id']."	".$row['last_name'].", ".$row['first_name']."	"; $getCompany = "SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$myCompID'"; $getC = mysqli_query($conn,$getCompany); while($rowX = mysqli_fetch_array($getC)){ echo $rowX['comp_code']; } echo "	"; $getPos = "SELECT `position_name` FROM `pms_positions_tbl` WHERE `id`='$myPosID'"; $getP = mysqli_query($conn,$getPos); while($rowP = mysqli_fetch_array($getP)){ echo $rowP['position_name']; } echo "	"; if($accSta == 0){ echo "Inactive"; }else{ echo "Active"; } echo "	";?> "; echo "

close(); } ?>