connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT INTO PartyGroup (Player1) VALUES ('$player')"; $query = mysqli_query($conn, $sql); $sql = "SELECT ID FROM PartyGroup WHERE Player1 = '$player'"; $query = mysqli_query($conn, $sql); while($row = mysqli_fetch_assoc($query)) { echo($row["ID"]); break; } $conn->close(); ?>