I am having a problem with a simple set of queries. This is what is happening-
Query1 Implements
Query2 DOES NOT IMPLEMENT
Query3 Implements
Can someone tell me what I am doing wrong? Here is my code:
################################
Membership Acceptance Page
################################
###################
Include files
###################
Include ("../OUTSIDE/ROOT.php");
#########################
Connect to Database
#########################
$TableName1 = "auth";
$Tablename2 = "profile";
$TableName3 = "bio";
$Link1 = mysql_connect($Host, $User, $Password);
mysql_select_db($DBName, $Link1);
##################
Make Queries
##################
$Query1 = "UPDATE $TableName1 SET confirm='1' WHERE auth.auth_id='$passvar'";
$Query2 = "UPDATE $TableName2 SET confirm='1' WHERE profile.profile_id='$passvar'";
$Query3 = "UPDATE $TableName3 SET confirm='1' WHERE bio.bio_id='$passvar'";
I am confused as to why Queries 1 and 3 go through but Query 2 does not?