<?php
                if(isset($_POST['submit'])) {
                    $cupname = $_POST['cupname'];
                    $team1 = $_POST['team1'];
                    $team2 = $_POST['team2'];
                    $team3 = $_POST['team3'];
                    $team4 = $_POST['team4'];

                    $zero = "0";

                    $result = mysql_query("INSERT INTO cupname (name) VALUES ('$cupname')");
                    $result = mysql_query("INSERT INTO teams (team1, team2, team3, team4) VALUES ('$team1', '$team2', '$team3', '$team4')");
                    $result = mysql_query("INSERT INTO wins (team1w, team2w, team3w, team4w) VALUES ($zero, $zero, $zero, $zero)");
                    $result = mysql_query("INSERT INTO draws (team1d, team2d, team3d, team4d) VALUES ($zero, $zero, $zero, $zero)");
                    $result = mysql_query("INSERT INTO looses (team1l, team2l, team3l, team4l) VALUES ($zero, $zero, $zero, $zero)");
                    $result = mysql_query("INSERT INTO points (team1p, team2p, team3p, team4p) VALUES ($zero, $zero, $zero, $zero)");
                echo "<h1>Turnering og lag lagt til!</h1>";
                }

                ?>

<?php
                $result = mysql_query("SELECT * FROM cupname ORDER BY id DESC");
                $result = mysql_query("SELECT * FROM teams ORDER BY id DESC");
                $result = mysql_query("SELECT * FROM wins ORDER BY id DESC");
                $result = mysql_query("SELECT * FROM draws ORDER BY id DESC");
                $result = mysql_query("SELECT * FROM looses ORDER BY id DESC");
                $result = mysql_query("SELECT * FROM points ORDER BY id DESC");
                    while($row = mysql_fetch_array($result)) {
                        $i=$i + 1;
                        echo "<table>";
                        echo "<tr>";
                        echo $row['name'];
                        echo "</tr>";
                        echo "<tr><td><b>Lag</b></td>
                        <td><b>Seiere</b></td>
                        <td><b>Uavgjort</b></td>
                        <td><b>Tap</b></td>
                        <td><b>Poeng</b></td>
                        </tr><tr><td>";
                        echo $row['team1'];
                        echo "</td><td>";
                        echo $row['team1w'];
                        echo "</td><td>";
                        echo  $row['team1d'];
                        echo "</td><td>";
                        echo  $row['team1l'];
                        echo "</td><td>";
                        echo  $row['team1p'];
                        echo "</td></tr><tr><td>";
                        echo  $row['team2'];
                        echo  "</td><td>";
                        echo  $row['team2w'];
                        echo "</td><td>";
                        echo  $row['team2d'];
                        echo "</td><td>";
                        echo  $row['team2l'];
                        echo "</td><td>";
                        echo  $row['team2p'];
                        echo "</td></tr><tr><td>";
                        echo  $row['team3'];
                        echo  "</td><td>";
                        echo  $row['team3w'];
                        echo "</td><td>";
                        echo  $row['team3d'];
                        echo "</td><td>";
                        echo  $row['team3l'];
                        echo "</td><td>";
                        echo  $row['team3p'];
                        echo "</td></tr><tr><td>";
                        echo  $row['team4'];
                        echo  "</td><td>";
                        echo  $row['team4w'];
                        echo "</td><td>";
                        echo  $row['team4d'];
                        echo "</td><td>";
                        echo  $row['team4l'];
                        echo "</td><td>";
                        echo  $row['team1p'];
                        echo "</td></tr></table><br /><hr /><br />";
                    }
                ?>

select
    tourn.id,
    tourn.name
from
    tournament
        join teams team
            on tourn.id=team.id
        join wins win
            on tourn.id=win.id

select
    tourn.id,
    tourn.name
from
    tournament
        right outer join teams team
            on tourn.id=team.id
        right outer join wins win
            on tourn.id=win.id