[perleo]

Hi, iam trying to take the two values of 2 input fields, compare them and if they are the same update the db, but it doesnt work, can someone fix this please

PHP Code:

<?php

/* Admin area for aircraft

Version 1.0

-colinok

*/

session_start();



  // check session variable



  if (isset($HTTP_SESSION_VARS['valid_user']))

{ //WORK WITHIN THE SESSION





include('../dbconnect.php');



$conn = db_connect();



  $mail1 = $HTTP_POST_VARS['mail1'];

  $mail2 = $HTTP_POST_VARS['mail2'];

  

if ($mail1 === $mail2)

{ // CHANGE EMAIL SECTION START

 echo 'E-Mails are the same';

 $mail1 = addslashes($mail1);

 $mail2 = addslashes($mail2);

 $query =("UPDATE pilots set email = '$mail1' where user = '$userid'");

        

} //CHANGE EMAIL SECTION END

  //IF EMAILS ARE DIFFERENT TELL THEM

else {

echo 'E-Mails are NOT the same';

      }

// IF NOT LOGGED IN TELL THEM 

} // 

else

  {

    echo '<p>You are not logged in.</p>';

    echo '<p>Only logged in members may see this page.</p>';

  }

?>

the $userid is the user logged in. So if the 2 input fields are the same, update the column email where the user is $userid, does the user column have to be a primary key, also the user column is the second column, would that cause a problem?

[NeverMind]

in your code you wrote:

PHP Code:

$query =("UPDATE pilots set email = '$mail1' where user = '$userid'"); 

but I can't find any variable labeled $userid in your script

also what exactly appear after you pass the 2 variables to this script ?

[perleo]

$userid was pre declared when you log in,

I get E-Mails are the same, which they are not, because i put in different emails in the two inputs