Can you tell me what is wrong with my code?
What I'm doing is this:
I have a form that users answer questions and then submit. The Action calles GET the same document, with all the form variables inserted in. What is supposed to happen is that php is supposed to enter the user's answers into our database, but only in the proper record (based on variable username). So the info for Joe_Smith is entered only into the record where the username field equals "Joe_Smith". I keep getting an error in query and don't know where I'm going wrong.
$server = "aaaa";
$user = "bbbbb";
$pass = "ccccc";
$db = "dddddt";
$connection = mysql_connect($server, $user, $pass);
// formulate and run query
$query = "insert into et01app_gen(lisalvation,lireasons,lifamilylife,lileadership,statusinterview) values('lisalvation','lireasons','lifamilylife','lileadership','statusinterview') where username=\'username\'";
mysql_db_query($db,$query,$connection) or die("Error in query");
THanks!
Jeof Oyster
Top Flight Leadership
What I'm doing is this:
I have a form that users answer questions and then submit. The Action calles GET the same document, with all the form variables inserted in. What is supposed to happen is that php is supposed to enter the user's answers into our database, but only in the proper record (based on variable username). So the info for Joe_Smith is entered only into the record where the username field equals "Joe_Smith". I keep getting an error in query and don't know where I'm going wrong.
$server = "aaaa";
$user = "bbbbb";
$pass = "ccccc";
$db = "dddddt";
$connection = mysql_connect($server, $user, $pass);
// formulate and run query
$query = "insert into et01app_gen(lisalvation,lireasons,lifamilylife,lileadership,statusinterview) values('lisalvation','lireasons','lifamilylife','lileadership','statusinterview') where username=\'username\'";
mysql_db_query($db,$query,$connection) or die("Error in query");
THanks!
Jeof Oyster
Top Flight Leadership