[PHP] joining tables and getting results in php query

[Publications]

I would like to be able to type in the username, select a change option and
then update a table that does not contain the username.
auth_user - contains user_id and username
userinfo - contains user_id and the field I want to update

What do I need to do fix this code?

 if ($userinfo) {
      if ($submit=='Unsubscribe') {
         $mail_list='N';
      } else {
         $mail_list='B';
      }
      $res=mysql_result("select user_id from auth_user where
username='$username'"); //how do I get this to relate to my next query?
      $res=mysql_query("replace into userinfo values
('$user_id','$mail_list')",$dbe);
      if ($res) {
         print "Email: $username ($mail_list)<br>\n";
      } else {
         print "Problems adding email to unsubscribe list: ";
         print mysql_error()."<br>\n";
      }
   }

   print "<form action=\"dontEmail.php\" method=get>\n";
   $sess->hidden_session();
   print "Email Address: ";
   print "<input type=text size=30 maxlength=100 name=\"username\">\n";
   print "<input type=submit name=\"submit\" value=\"Bad Email Address\">
\n";
   print "<input type=submit name=\"submit\" value=\"Unsubscribe\"><br>\n";
   print "</form>\n";


Thank you

Duffy Betterton
Director of Publications
[EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]