How Do I Use "foreach" Construct With Database Extraction

[Volitics]

Below are excerpts from two PHP scripts that I am working on. What I am wanting to do is determine if the $UserName variable exists in the database tables "California" and "NewYork". If the $UserName variable is present on the first iteration the script will output "UserName is in this table!" and so forth for each iteration.

I can't get the scripts below to work. Does anybody see what I am doing wrong?

//---------------- Login.php ----------------
echo "<form action=\"AdminPage.php\" method=\"post\">";
echo "Click Below To Proceed";
echo "<input type=\"hidden\" name=\"Textfield\"" . "[$California]" .">";
echo "<input type=\"hidden\" name=\"Textfield\"" . "[$NewYork]" .">";
echo "<input type=\"submit\" value=\"Click Here\"></form>";

//----------------- AdminPage.php ----------
$UserName = "pete1";
require "../quote/conf/config.inc.php";
foreach( $_POST['Textfield'] as $Key=>$Table )
{
$Query = "SELECT * FROM $Table WHERE UserName = '$UserName'";
$Result = mysql_db_query ($db_info[dbname], $Query, $db_connection);
// Fetch the results from the database.
while ($Row = mysql_fetch_array($Result)){
	if ($Row["UserName"]){
	echo "UserName in this table!";
		}
	}
}

Thanking you in advance.

Volitics

[DeltaRho2K]

Start by changing this:

if ($Row["UserName"]){

to this:

if ($Row['UserName']){

[Volitics]

DeltaRho2K;

Thank you for your response.

I figured out the problem. It was in the Login.php page. I did not have the values in the hidden fields right.

I fixed the values in the Login.php script and it's working ok now.

echo "<form action=\"AdminPage.php\" method=\"post\">";
echo "Click Below To Proceed";
echo "<input type=\"hidden\" name=\"Textfield"."[1]"."\" value=\"California\">";
echo "<input type=\"hidden\" name=\"Textfield"."[2]"."\" value=\"NewYork\">";
echo "<input type=\"submit\" value=\"Click Here\"></form>";

[DeltaRho2K]

I guess that would do it too 😉
Anyhow, glad you got it resolved...