I'm not understanding this:
ou could use a Recordset above the Server Validation code to check to see if there is a matching entry by filtering by both values. Then validate the value of:
<?php echo($Recordset1->TotalRows); ?> with number validation with a maximum of 0.
I did put the recordset in:
<?php require_once('../../Connections/tsrsports.php'); ?>
<?php require_once("../../webassist/form_validations/wavt_scripts_php.php"); ?>
<?php require_once("../../webassist/form_validations/wavt_validatedform_php.php"); ?>
<?php require_once('../../webassist/mysqli/queryobj.php'); ?>
<?php require_once('../../webassist/mysqli/rsobj.php'); ?>
<?php
$WADAMenugrad = new WA_MySQLi_RS("WADAMenugrad",$tsrsports,0);
$WADAMenugrad->setQuery("SELECT season, seasonID FROM season ORDER BY season ASC");
$WADAMenugrad->execute();?>
<?php
$playersFilter = new WA_MySQLi_RS("playersFilter",$tsrsports,1);
$playersFilter->setQuery("SELECT * FROM players WHERE player_name = ?");
$playersFilter->bindParam("s", "".(isset($_GET['grad'])?$_GET['grad']:"") ."", "-1"); //colname
$playersFilter->execute();
?>
<?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");
}
}
?>
<?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);
}
?>