[jonny3010]

hi ive got this change password script but i want it so change a memo value in the database instead of password plus no confirm and old password filed just one box that will change the the memo value in the data base please.

Heres the script i need changing please

Code:

<?php
session_start();
$error_message = "";
if(!isset($_SESSION['username']))
{
   $error_message = 'Not logged in!';
}
else
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
   $action = isset($_POST['action']) ? $_POST['action'] : '';
   $mysql_server = '77.68.105.107';
   $mysql_username = '*********';
   $mysql_password = '******';
   $mysql_database = '*******';
   $mysql_table = 'USERS';
   $success_page = './index.php';

   if ($action == 'changepassword')
   {
      $password_value = md5($_POST['password']);
      $newpassword = md5($_POST['newpassword']);
      $confirmpassword = md5($_POST['confirmpassword']);
      $username_value = $_SESSION['username'];
      if ($newpassword != $confirmpassword)
      {
         $error_message = 'The confirm new password must match the new password entry';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$]{1,50}$", $newpassword))
      {
         $error_message = 'New password is not valid, please check and try again!';
      }
      else
      {
         $db = mysql_connect($mysql_server, $mysql_username, $mysql_password);
         mysql_select_db($mysql_database, $db);
         $sql = "SELECT password FROM ".$mysql_table." WHERE username = '".$username_value."'";
         $result = mysql_query($sql, $db);
         if ($data = mysql_fetch_array($result))
         {
            if ($password_value == $data['password'])
            {
               $sql = "UPDATE `".$mysql_table."` SET `password` = '$newpassword' WHERE `username` = '$username_value'";
               mysql_query($sql, $db);
            }
            else
            {
               $error_message = 'Old password is not valid!';
            }
         }
         mysql_close($db);
         if (empty($error_message))
         {
            header('Location: '.$success_page);
            exit;
         }
      }
   }
}
?>

[penguinwebsoft]

Hi,

We are a leading website company based in India.We can do the work for you.

Email me back with details and budget for the work.

penguinwebsoft@gmail.com

Thanks,
Penguin Websoft

[newal3ab]

you should study php well

[Golith]

[UR request is a little blurry

But if your looking to chage a value in "memo" ? Memory : "huh" .. lol .. soz .. then a function that returns a value would be an approach as it wont update the Db.

Is this what you are asking?