prepare('SELECT * FROM manager_profile WHERE Manager_ID = ?'); $stmt->bind_param('s', $user_n); $stmt->execute(); $result = $stmt->get_result(); //$row = $result->fetch_assoc(); $count =$result->num_rows; if($count > 0) { $querys = "SELECT CF.Client_ID,RF.Category_Sender_ID,RF.Category_Receiver_ID,RF.Broker_Receiver_ID,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON BP.Manager_ID=RF.Manager_Receiver_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Receiver_ID='".$user_n."' Group By Reference_ID"; $resultss = $mysqli->query($querys); //echo $mysqli->error; while ($rowss = $resultss->fetch_assoc()) { $Reference_ID= $rowss["Reference_ID"]; $query = "SELECT CF.Client_ID,RF.Category_Sender_ID,RF.Category_Receiver_ID,RF.Broker_Receiver_ID,RF.Reference_ID_Follow_UP,RF.Reference_ID,RF.Broker_Sender_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.Cell_Phone,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON BP.Manager_ID=RF.Manager_Receiver_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Receiver_ID='".$user_n."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1"; $results = $mysqli->query($query); //echo $mysqli->error; while ($rows = $results->fetch_assoc()) { $Broker_Sender_ID= $rows["Broker_Sender_ID"]; $queryx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'"; $resultx = $mysqli->query($queryx); $rowx = $resultx->fetch_assoc(); $Category_ID = $rows['Category_Sender_ID']; $First_Name = $rowx['First_Name']; $Last_Name = $rowx['Last_Name']; $Broker_Sender_Name = $First_Name .' '. $Last_Name; $queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_ID."'"; $resultsss = $mysqli->query($queryss); $row = $resultsss->fetch_assoc(); $Broker_Receiver_ID= $rows["Broker_Receiver_ID"]; $queryxx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Receiver_ID."'"; $resultxx = $mysqli->query($queryxx); $rowxs = $resultxx->fetch_assoc(); $Category_Receiver_ID = $rows['Category_Receiver_ID']; $Firsts_Name = $rowxs['First_Name']; $Lasts_Name = $rowxs['Last_Name']; $Broker_Receiver_Name = $Firsts_Name .' '. $Lasts_Name; $queryssx = "SELECT * FROM Categories WHERE Category_ID='".$Category_Receiver_ID."'"; $resultsssx = $mysqli->query($queryssx); $rowx = $resultsssx->fetch_assoc(); ?>

prepare('SELECT * FROM manager_profile WHERE Manager_ID = ?'); $stmt->bind_param('s', $user_n); $stmt->execute(); $result = $stmt->get_result(); //$row = $result->fetch_assoc(); $count =$result->num_rows; if($count > 0) { $querys = "SELECT CF.Client_ID,RF.Reference_ID,RF.Category_Receiver_ID,RF.Category_Sender_ID,RF.Broker_Sender_ID,RF.Broker_Receiver_ID,RF.Transaction_Type,RF.Reference_Status,RF.Reg_Date,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON BP.Manager_ID=RF.Manager_Sender_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Sender_ID='".$user_n."' Group By Reference_ID"; $resultss = $mysqli->query($querys); //echo $mysqli->error; while ($rowss = $resultss->fetch_assoc()) { $Reference_ID= $rowss["Reference_ID"]; $query = "SELECT CF.Client_ID,RF.Reference_ID_Follow_UP,RF.Category_Sender_ID,RF.Broker_Sender_ID,RF.Category_Receiver_ID,RF.Reference_ID,RF.Broker_Receiver_ID,RF.Transaction_Type,RF.Transaction_Amount,RF.Reference_Status,RF.Reg_Date,RF.Note,CF.Cell_Phone,CF.First_Name AS Client_First_Name,CF.Last_Name AS Client_Last_Name,BP.Category_ID,BP.First_Name,BP.Last_Name,CA.Category_Type from Reference_File_Follow_UP RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID JOIN Broker_Profile BP ON BP.Manager_ID=RF.Manager_Sender_ID JOIN Categories CA ON CA.Category_ID=BP.Category_ID where RF.Manager_Sender_ID='".$user_n."' AND RF.Reference_ID='".$Reference_ID."' order by Reg_Date DESC Limit 1"; $results = $mysqli->query($query); //echo $mysqli->error; while ($rows = $results->fetch_assoc()) { $Broker_Receiver_ID= $rows["Broker_Receiver_ID"]; $queryx = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Receiver_ID."'"; $resultx = $mysqli->query($queryx); $rowx = $resultx->fetch_assoc(); $Category_ID = $rows['Category_Receiver_ID']; $First_Name = $rowx['First_Name']; $Last_Name = $rowx['Last_Name']; $Broker_Receiver_Name = $First_Name .' '. $Last_Name; $queryss = "SELECT * FROM Categories WHERE Category_ID='".$Category_ID."'"; $resultsss = $mysqli->query($queryss); $row = $resultsss->fetch_assoc(); $Broker_Sender_ID= $rows["Broker_Sender_ID"]; $queryxs = "SELECT * FROM Broker_Profile Where Broker_ID ='".$Broker_Sender_ID."'"; $resultxs = $mysqli->query($queryxs); $rowxs = $resultxs->fetch_assoc(); $Category_Sender_ID = $rows['Category_Sender_ID']; $First_Names = $rowxs['First_Name']; $Last_Names = $rowxs['Last_Name']; $Broker_Sender_Name = $First_Names .' '. $Last_Names; $queryssx = "SELECT * FROM Categories WHERE Category_ID='".$Category_Sender_ID."'"; $resultssss = $mysqli->query($queryssx); $rowx = $resultssss->fetch_assoc(); ?>