help help due today

[newbie12345]

im trying to update the user account but for some reason its not updating

can any one help me with my code.

 

this is my code

or is there another way i can accomplish this

 

i was getting a error

Notice: Undefined variable: users in C:\wamp\www\music website1\updateaccount.php on line 8

 

Notice: Undefined variable: users in C:\wamp\www\music website1\updateaccount.php on line 21

<?php

session_start();
include ('connect.php');

if (isset($_POST["submit"])){

$_SESSION['u_name']=$users;

      $user  = $_POST['u_name'];
  $first  =$_POST['f_name'];
  $last  = $_POST['l_name'];
  $birth   = $_POST['DOB'];
  $sex        = $_POST['gender'];
  $addres    = $_POST['address'];
  $pass   = $_POST['pwd'];
  $conpass    = $_POST['pwd1'];
  $eaddress  =$_POST['e_address'];
  

$sql= ("UPDATE user_accounts SET username = '$user', firstname = '$first', lastname = '$last', birthday = '$birth', gender = '$sex', address = '$addres', password = '$pass', confirm_password = '$conpass', email_address = '$eaddress' WHERE user_id = '$users'");																																											

$rest = mysql_query($sql);

if ($rest){
echo "Your account have successfully been updated";
}ELSE{
     echo "There was an error updating ur account.<br>Please contact site admin";
       }
  
    }
  


?>

[trq]

As the error suggests, $users isn't defined anywhere in your code.

[newbie12345]

i solved that problem but its not updating in the database

 

<?php

session_start();
include ('connect.php');

if (isset($_POST["submit"])){

  $users= $_SESSION['u_name'];

      $user  = $_POST['u_name'];
  $first  =$_POST['f_name'];
  $last  = $_POST['l_name'];
  $birth   = $_POST['DOB'];
  $sex        = $_POST['gender'];
  $addres    = $_POST['address'];
  $pass   = $_POST['pwd'];
  $conpass    = $_POST['pwd1'];
  $eaddress  =$_POST['e_address'];
  

$sql= ("UPDATE user_accounts SET username = '$user', firstname = '$first', lastname = '$last', birthday = '$birth', gender = '$sex', address = '$addres', password = '$pass', confirm_password = '$conpass', email_address = '$eaddress' WHERE user_id = '$users'");																																											

$rest = mysql_query($sql);

if ($rest){
echo "Your account have successfully been updated";
}ELSE{
     echo "There was an error updating ur account.<br>Please contact site admin";
       }
  
    }
  


?>

[trq]

Instead of your custom error message, lets see what mysql has to say.

 

if ($rest) {
    echo "Your account have successfully been updated";
} else {
    echo mysql_error() . "<br />$sql";
}

 

    }

[newbie12345]

did that but for some reason its not updating

[trq]

What error are you now seeing?