prepare('SELECT * FROM Broker_Profile WHERE Manager_ID = ? AND Broker_ID = ?');
$stmt->bind_param('ss', $user_n, $Client_ID);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
//$query = "SELECT DISTINCT Client_ID from Reference_File where Broker_Receiver_ID='".$user_n."' order by First_Name";
$query = "SELECT DISTINCT CF.Client_ID,CF.First_Name,CF.Last_Name from Reference_File RF JOIN Client_Profile CF ON RF.Client_ID=CF.Client_ID
where RF.Manager_Receiver_ID='".$user_n."' AND RF.Broker_Receiver_ID='".$Client_ID."' order by First_Name";
$result = $mysqli->query($query);
$_ResultSet = array();
while ($row = $result->fetch_assoc()) {
$_ResultSet[] = $row;
}
echo json_encode($_ResultSet);
}
}else
{
echo "Choose User";
}
?>