connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM PartyGroup WHERE ID = '$partyID'"; $query = mysqli_query($conn, $sql); if (mysqli_num_rows($query) > 0) { while ($row = mysqli_fetch_assoc($query)) { echo($row["Player1"]); echo("//"); if ($row["Player2"] != "null") echo($row["Player2"]); echo("//"); if ($row["Player3"] != "null") echo($row["Player3"]); echo("//"); if ($row["Player3"] != "null") echo($row["Player4"]); break; } } else { echo("Group removed"); } $conn->close(); ?>