Nefunkční zápis do databáze MySQL

Dobrý den

Prosím Vás kde je chyba v níže psaném kodu.
Vše kromě nick name to zapisuje do databáze. Tabulka v databázy vytvořená ale nezapusije to do ní.
Poradí někdo?

<?php
/*
Form to add a team
*/
    $confid = intval($_GET['conf']);

    if ($is_admin || full_check('manage_team') || permissions_check('manage_team',$confid) ) {

        $confname = getconf($confid);
        $seasonname = getseasonname($confid);
        print '<p><a href="' . $_SERVER['PHP_SELF'] . '">Domov</a> &raquo; <a href="' . $_SERVER['PHP_SELF'] . '?action=mainview&conf=' . $confid . '">' . $confname . ' conference</a> &raquo; Add team</p>' . "\n";
        print '<h2>Pridať tým do ' . $confname . ' conference (' . $seasonname . ')</h2>' . "\n";
        print "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "?action=addyes\">\n";
        print 'Team name: <input type="text" name="teamname" />' . "\n";
        print '<br />' . "\n";
        print 'Nick name: <input type="nickname" name="nickname"  />' . "\n";
        print '<br />' . "\n";
        print 'Master team: <select name="masterteam">' . "\n";
        print "\t" . '<option value="-2">-------</option>' . "\n";
        print "\t" . '<option value="-1">None (Create a new one)</option>' . "\n";
        print "\t" . '<option value="-2">-------</option>' . "\n"; 
        $querymasterteams = 'SELECT masterteamid, masterteamname FROM sportsdb_masterteams WHERE masterteamactive = 1 ORDER BY masterteamname';
        $resultmasterteams = mysql_query($querymasterteams);
        while ($masterteams = mysql_fetch_array($resultmasterteams, MYSQL_ASSOC)) {
            $masterteamname = htmlspecialchars($masterteams['masterteamname'], ENT_QUOTES);
            print "\t" . '<option value="' . $masterteams['masterteamid'] . '">' . $masterteamname . ' </option>' . "\n";
        }
        print "</select><br />\n"; 
        print "Divízia: <select name=\"teamdiv\">\n";
        $querydivs = "SELECT divid, divname FROM sportsdb_divs WHERE conference = $confid ORDER BY divorder";
        $resultdivs = mysql_query($querydivs);
        while ($divs = mysql_fetch_array($resultdivs, MYSQL_ASSOC)) {
            print "<option value=\"{$divs['divid']}\">{$divs['divname']}</opt ion>\n";
        }
        print "</select><br />\n";
        print "<input type=\"hidden\" name=\"confid\" value=\"$confid\" />\n";
        print "<input type=\"submit\" value=\"Add\" />\n";
        print "</form>\n";
        print '<form method="get" action="' . $_SERVER['PHP_SELF'] . "\">\n";
        print "<input type=\"hidden\" name=\"action\" value=\"mainview\" />\n";
        print "<input type=\"hidden\" name=\"conf\" value=\"$confid\" />\n";
        print "<input type=\"submit\" value=\"Cancel\" />\n";
        print "</form>\n";
    }
    else {
        die($text_no_perm);
    }
?>

Doplněn tag CODE.
Změna předmětu, původně: Nefunkční zápis do databáze. (host)