rendered paste body<?php require_once('../Connections/szvvweb.php'); ?><?php ob_start();//geen cacheheader("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 classesrequire_once('../includes/common/KT_common.php');if (!isset($_SESSION)) { session_start();}// Load the tNG classesrequire_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 triggerif (!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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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"> <?phpdo { ?> <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> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </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><?phpmysql_free_result($editver);mysql_free_result($editteams);mysql_free_result($kleuren);mysql_free_result($klasse);?>