Here's what I have. not working. The insert works but it's not stopping the duplicate
<?php
$WADAMenugrad = new WA_MySQLi_RS("WADAMenugrad",$tsrsports,0);
$WADAMenugrad->setQuery("SELECT season, seasonID FROM season ORDER BY season ASC");
$WADAMenugrad->execute();
?>
<?php
if (isset($_POST["Insert"]) || isset($_POST["Insert_x"])) {
$InsertQuery = new WA_MySQLi_Query($tsrsports);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "players";
$InsertQuery->bindColumn("player_name", "s", "".((isset($_POST["player_name"]))?$_POST["player_name"]:"") ."", "WA_BLANK");
$InsertQuery->bindColumn("grad", "s", "".((isset($_POST["grad"]))?$_POST["grad"]:"") ."", "WA_BLANK");
$InsertQuery->saveInSession("WADA_Insert_players");
$InsertQuery->execute();
$InsertGoTo = "players3_insert.php?playerID=[Insert_ID]";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
<?php
if ((isset($_POST["Insert"]) || isset($_POST["Insert_x"]))) {
$WAFV_Redirect = "".($_SERVER["REQUEST_URI"]) ."?invalid=true";
$_SESSION['WAVT_players3insert_Errors'] = "";
if ($WAFV_Redirect == "") {
$WAFV_Redirect = $_SERVER["PHP_SELF"];
}
$WAFV_Errors = "";
$WAFV_Errors .= WAValidateRQ((isset($_POST["player_name"])?$_POST["player_name"]:"") . "",true,1);
$WAFV_Errors .= WAValidateUnique(("tsrsports"),$tsrsports,$database_tsrsports,"players","playerID","none,none,NULL","0","player_name","',none,''","".((isset($_POST["player_name"]))?$_POST["player_name"]:"") ."",true,2);
$WAFV_Errors .= WAValidateRQ((isset($_POST["grad"])?$_POST["grad"]:"") . "",true,3);
if ($WAFV_Errors != "") {
PostResult($WAFV_Redirect,$WAFV_Errors,"players3insert");
}
}
?>