<?php
$servername = "127.0.0.1";
$username = "pipplsql1";
$password = "MySQL-Unlock";
$dbname = "pipplsql1";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT homeTable.name, homeTable.x, homeTable.y, homeTable.z, BAT_players.BAT_player, BAT_players.lastlogin, BungeeOnlineTime.OnlineTime, BungeeOnlineTime.Player
        FROM homeTable
        INNER JOIN BAT_players ON BAT_players.BAT_player = homeTable.name
        INNER JOIN BungeeOnlineTime ON BungeeOnlineTime.Player = homeTable.name
        WHERE BAT_players.lastlogin < (CURDATE() - INTERVAL 21 DAY)
        ORDER BY BAT_players.lastlogin ASC;";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {

        echo "<table><tr><td width='50%'><b>Name:</b> " . $row["name"]. " <b>- Letztes mal Online:</b> " . $row["lastlogin"]. " <b>- x:</b> " . $row["x"]. " <b>- y:</b> " . $row["y"]. " <b>- z:</b> " . $row["z"]. " <b>- Zeit Online:</b> " . $row["OnlineTime"]. "</td> </tr></table><br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>