$t_id = $row["team_id"]; $gameid = "select game_id from game where play_date='{$v->dGame}' AND team1_id={$t_id}"; $gameID = $con->query($gameid); if ($gameID->num_rows > 0) { while ($row1 = $gameID->fetch_assoc()) { $id = $row1["game_id"]; $cardId = $k + 1; $sql = "update card SET game_id = {$id} WHERE card_id='{$cardId}'"; mysqli_query($con, $sql); } } } } } //---------------------------GoalsScored---------------------------------- $result = $client->GoalsScored(array("iGameId" => "")); $goals = $result->GoalsScoredResult->tGoal; foreach ($goals as $k => $v) { $sql = "insert into goal (goal_id,iminutes) value({$k}+1,{$v->iMinute})"; mysqli_query($con, $sql); $playerid = "select player_id from player where player_name='{$v->sPlayerName}'"; $playerID = $con->query($playerid); if ($playerID->num_rows > 0) { while ($row = $playerID->fetch_assoc()) { $id = $row["player_id"]; $goalId = $k + 1; $sql = "update goal SET player_id = {$id} WHERE goal_id='{$goalId}'"; mysqli_query($con, $sql); } } $teamid = "select team_id from team where team_name='{$v->sTeamName}'";