prepare('SELECT * FROM Broker_Profile WHERE Manager_ID = ? AND Broker_ID = ?');
$stmt->bind_param('ss', $user_n, $Broker_ID);
$stmt->execute();
$result = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
//$Client_Name= $_POST["user"];
$user_n=$_SESSION['user_id'];
$stmt = $mysqli->prepare('SELECT * FROM Broker_Profile WHERE Broker_ID = ?');
$stmt->bind_param('s', $Broker_ID);
$stmt->execute();
$result = $stmt->get_result();
//$row = $result->fetch_assoc();
$count =$result->num_rows;
if($count > 0)
{
$query = "SELECT Reference_Status_ID,Reference_Status_Name from Reference_Status";
$results = $mysqli->query($query);
//echo $mysqli->error;
while ($rows = $results->fetch_assoc()) {
$_ResultSet[] = $rows;
}
echo json_encode($_ResultSet);
}
}
}else
{
echo "Choose User";
}
?>