<?php require_once('../Connections/szvvweb.php'); ?>
<?php ob_start();
//geen cache
header("Expires: Mon, 26 Jul 1990 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
 require_once('../Connections/szvvweb.php'); 
// Load the common classes
require_once('../includes/common/KT_common.php');
if (!isset($_SESSION)) {
  session_start();
}
// Load the tNG classes
require_once('../includes/tng/tNG.inc.php');

// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("../");

// Make unified connection variable
$conn_szvvweb = new KT_connection($szvvweb, $database_szvvweb);

// Start trigger
$formValidation = new tNG_FormValidation();
$tNGs->prepareValidation($formValidation);
// End trigger

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "editteam")) {
  $updateSQL = sprintf("UPDATE teams SET klasse_team=%s, naam_team=%s, shirt1_team=%s, shirt2_team=%s, shirt3_team=%s, broek1_team=%s, broek2_team=%s, broek3_team=%s, kous1_team=%s, kous2_team=%s, kous3_team=%s WHERE id_team=%s",
                       GetSQLValueString($_POST['klasse_team'], "int"),
                       GetSQLValueString($_POST['naam_team'], "text"),
                       GetSQLValueString($_POST['shirt1_team'], "text"),
                       GetSQLValueString($_POST['shirt2_team'], "text"),
                       GetSQLValueString($_POST['shirt3_team'], "text"),
                       GetSQLValueString($_POST['broek1_team'], "text"),
                       GetSQLValueString($_POST['broek2_team'], "text"),
                       GetSQLValueString($_POST['broek3_team'], "text"),
                       GetSQLValueString($_POST['kous1_team'], "text"),
                       GetSQLValueString($_POST['kous2_team'], "text"),
                       GetSQLValueString($_POST['kous3_team'], "text"),
                       GetSQLValueString($_POST['id_team'], "int"));

  mysql_select_db($database_szvvweb, $szvvweb);
  $Result1 = mysql_query($updateSQL, $szvvweb) or die(mysql_error());

  $updateGoTo = "index.php?page=editver&id_ver=" . $row_editver['id_ver'] . "";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE verenigingen SET naam_ver=%s, sec_ver=%s, adres_ver=%s, pc_ver=%s, plaats_ver=%s, tel_ver=%s, mob_ver=%s, email_ver=%s, www_ver=%s, knvb_ver=%s WHERE id_ver=%s",
                       GetSQLValueString($_POST['naam_ver'], "text"),
                       GetSQLValueString($_POST['sec_ver'], "text"),
                       GetSQLValueString($_POST['adres_ver'], "text"),
                       GetSQLValueString($_POST['pc_ver'], "text"),
                       GetSQLValueString($_POST['plaats_ver'], "text"),
                       GetSQLValueString($_POST['tel_ver'], "text"),
                       GetSQLValueString($_POST['mob_ver'], "text"),
                       GetSQLValueString($_POST['email_ver'], "text"),
                       GetSQLValueString($_POST['www_ver'], "text"),
                       GetSQLValueString($_POST['knvb_ver'], "text"),
                       GetSQLValueString($_POST['id_ver'], "int"));

  mysql_select_db($database_szvvweb, $szvvweb);
  $Result1 = mysql_query($updateSQL, $szvvweb) or die(mysql_error());

  $updateGoTo = "index.php?page=vers";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

$colname_editver = "-1";
if (isset($_GET['id_ver'])) {
  $colname_editver = $_GET['id_ver'];
}
mysql_select_db($database_szvvweb, $szvvweb);
$query_editver = sprintf("SELECT * FROM verenigingen WHERE id_ver = %s", GetSQLValueString($colname_editver, "int"));
$editver = mysql_query($query_editver, $szvvweb) or die(mysql_error());
$row_editver = mysql_fetch_assoc($editver);
$totalRows_editver = mysql_num_rows($editver);

$colname_editteams = "-1";
if (isset($_GET['id_ver'])) {
  $colname_editteams = $_GET['id_ver'];
}
mysql_select_db($database_szvvweb, $szvvweb);
$query_editteams = sprintf("SELECT * FROM teams WHERE idver_team = %s ORDER BY naam_team ASC", GetSQLValueString($colname_editteams, "int"));
$editteams = mysql_query($query_editteams, $szvvweb) or die(mysql_error());
$row_editteams = mysql_fetch_assoc($editteams);
$totalRows_editteams = mysql_num_rows($editteams);

mysql_select_db($database_szvvweb, $szvvweb);
$query_kleuren = "SELECT * FROM kleuren ORDER BY naam_kleur ASC";
$kleuren = mysql_query($query_kleuren, $szvvweb) or die(mysql_error());
$row_kleuren = mysql_fetch_assoc($kleuren);
$totalRows_kleuren = mysql_num_rows($kleuren);

mysql_select_db($database_szvvweb, $szvvweb);
$query_klasse = "SELECT * FROM klasse ORDER BY id_klasse ASC";
$klasse = mysql_query($query_klasse, $szvvweb) or die(mysql_error());
$row_klasse = mysql_fetch_assoc($klasse);
$totalRows_klasse = mysql_num_rows($klasse);

// Make an insert transaction instance
$ins_teams = new tNG_insert($conn_szvvweb);
$tNGs->addTransaction($ins_teams);
// Register triggers
$ins_teams->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_teams->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_teams->registerTrigger("END", "Trigger_Default_Redirect", 99, "index.php?page=editver&id_ver=" . $row_editver['id_ver'] . "");
// Add columns
$ins_teams->setTable("teams");
$ins_teams->addColumn("klasse_team", "NUMERIC_TYPE", "POST", "klasse_team");
$ins_teams->addColumn("naam_team", "STRING_TYPE", "POST", "naam_team2");
$ins_teams->addColumn("shirt1_team", "STRING_TYPE", "POST", "shirt1_team");
$ins_teams->addColumn("shirt2_team", "STRING_TYPE", "POST", "shirt2_team2");
$ins_teams->addColumn("shirt3_team", "STRING_TYPE", "POST", "shirt3_team");
$ins_teams->addColumn("broek1_team", "STRING_TYPE", "POST", "broek1_team");
$ins_teams->addColumn("broek2_team", "STRING_TYPE", "POST", "broek2_team2");
$ins_teams->addColumn("broek3_team", "STRING_TYPE", "POST", "broek3_team2");
$ins_teams->addColumn("kous1_team", "STRING_TYPE", "POST", "kous1_team");
$ins_teams->addColumn("kous2_team", "STRING_TYPE", "POST", "kous2_team2");
$ins_teams->addColumn("kous3_team", "STRING_TYPE", "POST", "kous3_team2");
$ins_teams->addColumn("idver_team", "NUMERIC_TYPE", "POST", "idver_team", "{editver.id_ver}");
$ins_teams->setPrimaryKey("idver_team", "NUMERIC_TYPE");

// Execute all the registered transactions
$tNGs->executeTransactions();

// Get the transaction recordset
$rsteams = $tNGs->getRecordset("teams");
$row_rsteams = mysql_fetch_assoc($rsteams);
$totalRows_rsteams = mysql_num_rows($rsteams);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="../includes/common/js/base.js" type="text/javascript"></script>
<script src="../includes/common/js/utility.js" type="text/javascript"></script>
<script src="../includes/skins/style.js" type="text/javascript"></script>
<?php echo $tNGs->displayValidationRules();?>
<link href="../public.css" rel="stylesheet" type="text/css" />
<link href="../includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
</head>
<body>
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
  <table align="left">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Verenigingsnummer:</td>
      <td><input name="textfield" type="text" id="textfield" value="<?php echo $row_editver['id_ver']; ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Naam:</td>
      <td><input type="text" name="naam_ver" value="<?php echo htmlentities($row_editver['naam_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Secretaris:</td>
      <td><input type="text" name="sec_ver" value="<?php echo htmlentities($row_editver['sec_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Adres:</td>
      <td><input type="text" name="adres_ver" value="<?php echo htmlentities($row_editver['adres_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Postcode:</td>
      <td><input type="text" name="pc_ver" value="<?php echo htmlentities($row_editver['pc_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Plaats:</td>
      <td><input type="text" name="plaats_ver" value="<?php echo htmlentities($row_editver['plaats_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Telefoon:</td>
      <td><input type="text" name="tel_ver" value="<?php echo htmlentities($row_editver['tel_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Mobiel:</td>
      <td><input type="text" name="mob_ver" value="<?php echo htmlentities($row_editver['mob_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">E-mail:</td>
      <td><input type="text" name="email_ver" value="<?php echo htmlentities($row_editver['email_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Website:</td>
      <td><input type="text" name="www_ver" value="<?php echo htmlentities($row_editver['www_ver'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">KNVB Nummer:</td>
      <td><input name="knvb_ver" type="text" id="knvb_ver" value="<?php echo $row_editver['knvb_ver']; ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><input type="hidden" name="id_ver" value="<?php echo $row_editver['id_ver']; ?>" /></td>
      <td><input type="submit" value="Opslaan" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_update" value="form1" />
</form>
<?php if ($totalRows_editteams > 0) { // Show if recordset not empty ?>
  <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td><strong>Teams</strong></td>
      <td align="right"><a href="#" onclick="Spry.Utils.updateContent('main', 'vers.php'); return false;"><img src="../images/sync.gif" width="16" height="16" border="0" align="texttop" /> Terug</a></td>
    </tr>
    <?php do { ?>
      <tr>
        <td colspan="2"><form id="editteam" name="editteam" method="POST" action="<?php echo $editFormAction; ?>">
            <table border="0" align="right" cellpadding="0" cellspacing="0">
              <tr>
                <td> Naam:</td>
                <td colspan="3"><input name="naam_team" type="text" id="naam_team" value="<?php echo $row_editteams['naam_team']; ?>" /></td>
              </tr>
              <tr>
                <td>Klasse:</td>
                <td colspan="3"><select name="klasse_team" id="klasse_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_klasse['nr_klasse']?>"<?php if (!(strcmp($row_klasse['nr_klasse'], $row_editteams['klasse_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_klasse['naam_klasse']?></option>
                    <?php
} while ($row_klasse = mysql_fetch_assoc($klasse));
  $rows = mysql_num_rows($klasse);
  if($rows > 0) {
      mysql_data_seek($klasse, 0);
	  $row_klasse = mysql_fetch_assoc($klasse);
  }
?>
                  </select></td>
              </tr>
              <tr>
                <td>Shirt Kleuren: </td>
                <td><select name="shirt1_team" id="shirt1_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['shirt1_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="shirt2_team" id="shirt2_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['shirt2_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="shirt3_team" id="shirt3_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['shirt3_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
              </tr>
              <tr>
                <td>Broek Kleuren:</td>
                <td><select name="broek1_team" id="broek1_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['broek1_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="broek2_team" id="broek2_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['broek2_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="broek3_team" id="broek3_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['broek3_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
              </tr>
              <tr>
                <td>Kous Kleuren:</td>
                <td><select name="kous1_team" id="kous1_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['kous1_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="kous2_team" id="kous2_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['kous2_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
                <td><select name="kous3_team" id="kous3_team">
                    <?php
do {  
?>
                    <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_editteams['kous3_team']))) {echo "selected=\"selected\"";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
                    <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
                  </select></td>
              </tr>
              <tr>
                <td><input name="id_team" type="hidden" id="id_team" value="<?php echo $row_editteams['id_team']; ?>" /></td>
                <td><input type="submit" name="button2" id="button2" value="Opslaan" /></td>
                <td><a href="delteam.php?id_team=<?php echo $row_editteams['id_team']; ?>" onclick="return confirm('Weet u het zeker?')">verwijderen</a></td>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
              </tr>
            </table>
            <input type="hidden" name="MM_update" value="editteam" />
          </form></td>
      </tr>
      <?php } while ($row_editteams = mysql_fetch_assoc($editteams)); ?>
  </table>
  <?php } // Show if recordset not empty ?>
<?php
	echo $tNGs->getErrorMsg();
?>
<form action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>" method="post" name="form3" id="form3">
  <table align="left" cellpadding="2" cellspacing="0" class="KT_tngtable">
    <tr>
      <td colspan="2" class="KT_th"><strong>nieuw team toevoegen</strong></td>
    </tr>
    <tr>
      <td class="KT_th">Naam:</td>
      <td><input type="text" name="naam_team2" id="naam_team2" value="<?php echo KT_escapeAttribute($row_rsteams['naam_team']); ?>" size="32" />
        <?php echo $tNGs->displayFieldError("teams", "naam_team"); ?></td>
    </tr>
    <tr>
      <td class="KT_th"><label for="klasse_team">Klasse:</label></td>
      <td><select name="klasse_team" id="klasse_team">
          <?php 
do {  
?>
          <option value="<?php echo $row_klasse['nr_klasse']?>"<?php if (!(strcmp($row_klasse['nr_klasse'], $row_rsteams['klasse_team']))) {echo "SELECTED";} ?>><?php echo $row_klasse['naam_klasse']?></option>
          <?php
} while ($row_klasse = mysql_fetch_assoc($klasse));
  $rows = mysql_num_rows($klasse);
  if($rows > 0) {
      mysql_data_seek($klasse, 0);
	  $row_klasse = mysql_fetch_assoc($klasse);
  }
?>
        </select>
        <?php echo $tNGs->displayFieldError("teams", "klasse_team"); ?> </td>
    </tr>
    <tr>
      <td class="KT_th"><label for="shirt1_team">Shirt Kleuren:</label></td>
      <td><select name="shirt1_team" id="shirt1_team">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['shirt1_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="shirt2_team2" id="shirt2_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['shirt2_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="shirt3_team2" id="shirt3_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['shirt3_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select></td>
    </tr>
    <tr>
      <td class="KT_th"><label for="broek1_team">Broek Kleuren:</label></td>
      <td><select name="broek1_team" id="broek1_team">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['broek1_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="broek2_team2" id="broek2_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['broek2_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="broek3_team2" id="broek3_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['broek3_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select></td>
    </tr>
    <tr>
      <td class="KT_th"><label for="kous1_team">Kous Kleuren:</label></td>
      <td><select name="kous1_team" id="kous1_team">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['kous1_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="kous2_team2" id="kous2_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['kous2_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select>
        <select name="kous3_team2" id="kous3_team2">
          <?php 
do {  
?>
          <option value="<?php echo $row_kleuren['code_kleur']?>"<?php if (!(strcmp($row_kleuren['code_kleur'], $row_rsteams['kous3_team']))) {echo "SELECTED";} ?>><?php echo $row_kleuren['naam_kleur']?></option>
          <?php
} while ($row_kleuren = mysql_fetch_assoc($kleuren));
  $rows = mysql_num_rows($kleuren);
  if($rows > 0) {
      mysql_data_seek($kleuren, 0);
	  $row_kleuren = mysql_fetch_assoc($kleuren);
  }
?>
        </select></td>
    </tr>
    <tr class="KT_buttons">
      <td colspan="2"><input type="submit" name="KT_Insert1" id="KT_Insert1" value="Opslaan" />
      </td>
    </tr>
  </table>
  <input type="hidden" name="idver_team" id="idver_team" value="<?php echo KT_escapeAttribute($row_rsteams['idver_team']); ?>" />
</form>
</body>
</html>
<?php
mysql_free_result($editver);

mysql_free_result($editteams);

mysql_free_result($kleuren);

mysql_free_result($klasse);
?>