Redirect if username exist in TWO fields.
I want to check not only one field but two if a username exists and compare it with only one of the columns in the database. For example I have a form which has field 1= blue and field 2= red. My database does not contain the word blue- but it does contain red in the colors column. How can I alter the redirect so it checks for both blue and red in the database. I was thinking something like the following...
$MM_dupKeyRedirect="../nameused.php";
$loginUsername = $_POST['redfield'][bluefield'];
$LoginRS__query = sprintf("SELECT RESTRCTR FROM dl_rstrctr WHERE RESTRCTR=%s", GetSQLValueString($loginUsername, "text"));
mysql_select_db($database_Xconn, $Xconn);
$LoginRS=mysql_query($LoginRS__query, $Xconn) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
You can see where I thought adding both the redfield and bluefield follwing $_POST would work. Am I way off here?