//------------------------AllDefenders------------------------------------
$result = $client->AllDefenders(array("sCountryName" => ""));
$Alldefenders = $result->AllDefendersResult->string;
foreach ($Alldefenders as $k => $v) {
    $sql = "UPDATE player SET position='defender'WHERE player_name='{$v}'";
    mysqli_query($con, $sql);
}
//------------------------AllGoalKeepers------------------------------------
$result = $client->AllGoalKeepers(array("sCountryName" => ""));
$Allgoalk = $result->AllGoalKeepersResult->string;
foreach ($Allgoalk as $k => $v) {
    $sql = "UPDATE player SET position='goal_keeper'WHERE player_name='{$v}'";
    mysqli_query($con, $sql);
}
//------------------------AllForwards------------------------------------
$result = $client->AllForwards(array("sCountryName" => ""));
$AllForwards = $result->AllForwardsResult->string;
foreach ($AllForwards as $k => $v) {
    $sql = "UPDATE player SET position='forward'WHERE player_name='{$v}'";
    mysqli_query($con, $sql);
}
//------------------------AllMidFields------------------------------------
$result = $client->AllMidFields(array("sCountryName" => ""));
$AllMidFields = $result->AllMidFieldsResult->string;
foreach ($AllMidFields as $k => $v) {
    $sql = "UPDATE player SET position='mid_field'WHERE player_name='{$v}'";
    mysqli_query($con, $sql);
}
//---------------------------TeamsCompeteList---------------------------------
$team = $client->TeamsCompeteList(array());
$teamresult = $team->TeamsCompeteListResult->tTeamCompete;