I have a program that parses information from one form to 3 different tables. I am kinda perplexed at the fact that I have sat here for hours and tried everything- with no query being sent to any table, here is the snippet of code that places them in the Tables:
This is the last revision of this code that I have tried so far:
#######################################################
Connect to the Database using the above variables.
#######################################################
$Link1 = mysql_connect($Host, $User, $Password);
#########################################
##Now place the data into the DataBase.##
#########################################
$Query1 = "INSERT into profile values ('0','$email','$fname','$lname','$age','$dob','$occupation','$country','$city','$state','$timezone','$interest')";
print ("The Query is:<br>$Query<p>\n");
if (mysql_db_query ($DBName, $Query, $Link1)) {
print ("Sucessful!!!");
}
else {
print (mysql_error());
}
mysql_close ($Link1);
$Link2 = mysql_connect($Host, $User, $Password);
$Query2 = "INSERT into bio values ('0','$cname','$species','$cage','$cgender','$force','$pro1','$pro2','$chistory','$imageurl')";
print ("The Query is:<br>$Query<p>\n");
if (mysql_db_query ($DBName, $Query, $Link2)) {
print ("Sucessful!!!");
}
else {
print (mysql_error());
}
mysql_close ($Link2);
$Link3 = mysql_connect($Host, $User, $Password);
$Query3 = "INSERT into auth values ('0','$uuser1','$ppass1','$auth_code','$admin','$security','$diplomatic','economic','intelligence','senate','justice')";
print ("The Query is:<br>$Query<p>\n");
if (mysql_db_query ($DBName, $Query, $Link3)) {
print ("Sucessful!!!");
}
else {
print (mysql_error());
}
mysql_close ($Link3);
