Buonasera, a tutti ho un problema qui:
$sql = "SELECT * FROM fantaincontro INNER JOIN team ON team.id = fantaincontro.teamAway INNER JOIN team ON team.id = fantaincontro.teamHome WHERE fantaincontro.season LIKE '%$seasonFilter%' and fantaincontro.id LIKE '%$idnameFilter%' ORDER BY fantaincontro.id DESC";
credo che il problema si che richiamo 2 volte team.id?
grazie
$sql = "SELECT * FROM fantaincontro INNER JOIN team ON team.id = fantaincontro.teamAway INNER JOIN team ON team.id = fantaincontro.teamHome WHERE fantaincontro.season LIKE '%$seasonFilter%' and fantaincontro.id LIKE '%$idnameFilter%' ORDER BY fantaincontro.id DESC";
credo che il problema si che richiamo 2 volte team.id?
grazie