You might discover you have a possible problem with this piece of your code...

PHP Code:

if($newpassword=$confirmnewpassword) 


you need to use 2 ='s when testing validity, using 1 will always result in a true

ie

PHP Code:

$var1 = "yes";
$var2 = "no";

if ($var1 = $var2) // says "make $var1 equal to $var2" and will result in $var1 now being "no"

if ($var1 == $var2) // says "is $var1 equal to $var2?"  this would result in FALSE 


clear?

Lite...

Originally Posted by rungss

I think this should work

<?php
$connection=mysql_connect("localhost","USERNAME"," PASSWORD");
$db=mysql_select_db("DATABASENAME",$connection);
$result = mysql_query("select password from passwordtable where username=$_POST['username']");
if(!$result)
{
echo "oops! The Username you entered does not exist";
}
else
if($_POST['password']!= mysql_result($result, 0))
{
echo "You entered an incorrect password";
}
else if($_POST['newpassword']!=$_POST['confirmnewpasssword'])
{
echo "The new password and confirm new password fields must be the same";
}
else
$sql=mysql_query(UPDATE passwordtable SET password=$_POST['newpassword'] where username=$_POST['username']);
if($sql)
{
echo "Congratulations You have successfully changed your password";
}
?>

Dude yor Script was ok but there are some systax error.
1. $result = mysql_query("select password from auth_users where username='$_POST[username]'");

2. $sql=mysql_query("UPDATE auth_users SET password='$_POST[newpassword]' where username='$_POST[username]'");


thats it.... Then this code will work..100% working

Originally Posted by rungss

I think this should work

<?php
$connection=mysql_connect("localhost","USERNAME"," PASSWORD");
$db=mysql_select_db("DATABASENAME",$connection);
$result = mysql_query("select password from passwordtable where username=$_POST['username']");
if(!$result)
{
echo "oops! The Username you entered does not exist";
}
else
if($_POST['password']!= mysql_result($result, 0))
{
echo "You entered an incorrect password";
}
else if($_POST['newpassword']!=$_POST['confirmnewpasssword'])
{
echo "The new password and confirm new password fields must be the same";
}
else
$sql=mysql_query(UPDATE passwordtable SET password=$_POST['newpassword'] where username=$_POST['username']);
if($sql)
{
echo "Congratulations You have successfully changed your password";
}
?>

Dude your Script was ok but there are some systax errors.
1. $result = mysql_query("select password from auth_users where username='$_POST[username]'");

2. $sql=mysql_query("UPDATE auth_users SET password='$_POST[newpassword]' where username='$_POST[username]'");


thats it.... Then this code will work..100% working

hye all...can someone help me...
i think i dont know where to put all the codding to make it works...
such as "form" and "button"....

currently do my final project...><
plz help me....

You do realise this thread is SIX YEARS OLD

And if you don't know about forms and buttons a HTML form tutorial is probably the best place to start.

You could do a search for member registration scripts in PHP for some ideas

if (isset($_POST['password']) && empty($_POST['password']))
{
$_POST['password'] = $row_getUser['password'];
}
else if (isset($_POST['password']))
{
$_POST['password'] = sha1($_POST['password']);
}
else
{
// do nothing!
}

THIS PHP code will change the password and encrypt it ("posted" from a form into a database)... I built a MySQL database "MyISAM"<-- engine and tested it.

cheers
Andre

Ermmm I would have thought that after...

EIGHT YEARS

The problem would have been solved several times over.

Originally Posted by chrishirst

Ermmm I would have thought that after...

EIGHT YEARS

The problem would have been solved several times over.

Oh, I'm sure it was a hard nut to crack. Eight years seems perfectly reasonable