Insert page: Check and validate against 2 database fields
I have the following code. I'm trying to validate against 2 database fields before insert. If player_name and grad_year are the same don't allow the insert. This code works but it only works on player_name. It's ignoring the second part of my query. It looks like I have the query correct so I'm guessing it's the order or syntax of the php script. Any help appreciated.
<?php
//check.php
if(isset($_POST["Insert"]))
{
$player_name = mysqli_real_escape_string($connect, $_POST["player_name"]);
$grad_year = mysqli_real_escape_string($connect, $_POST["grad_year"]);
$query = "SELECT * FROM players WHERE player_name = '".$player_name."'AND grad_year = '".$grad_year."' ";
$result = mysqli_query($connect, $query);
echo mysqli_num_rows($result);
}
{
$InsertQuery = new WA_MySQLi_Query($tsrbase);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "players";
$InsertQuery->bindColumn("player_name", "s", "".((isset($_POST["player_name"]))?$_POST["player_name"]:"") ."", "WA_BLANK");
$InsertQuery->bindColumn("grad_year", "d", "".((isset($_POST["grad_year"]))?$_POST["grad_year"]:"") ."", "WA_ZERO");
$InsertQuery->saveInSession("WADA_Insert_players");
$InsertQuery->execute();
$InsertGoTo = "playersInsert.php?NewPW=Yes";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>