Jump to content


Photo

Mysql update information problem!


  • Please log in to reply
1 reply to this topic

#1 benfla

benfla
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 17 May 2003 - 11:22 PM

hi, I read the mysql tutorial on how to make it so you can have members on your site, but the password was randomly made and given to you so I decided to make a form so you can change your password the only problem is when I submit it it doesnt give me any errors, but it also doesnt update the information
heres the code I\'m using now:
<?php

include \'db.php\';

	if(!$yourusername){

  echo "user name is a required field. Please enter it below.<br />";

	}

	if(!$newpassword){

  echo "new password is a required field. Please enter it below.<br />";

	}

	if(!$currentpass){

  echo "current password is a required field. Please enter it below.<br/>"; 

	}	

include \'newpassword.html\';

	exit();



if ($newpassword = $checkpassword){

} else { 

echo \'Your new password does not match!\';

exit();

} 

$encodedcurrentpass = md5($currentpass);

$encodednewpassword = md5($newpassword);

($sql = mysql_query("UPDATE users SET password=\'$encodednewpassword\' WHERE username=\'$yourusername\' AND password=\'$encodedcurrentpass\'"));

if (!$sql) {

echo \'Your password hasnt been changed! there was an error changing your password\';

} else {

echo \'Your password has been changed!\';

}

?>
Im sorta new to this so i dont know whats wrong
if you could help me I would really appreciate it.
The mighty cow Says "MOO"

#2 pallevillesen

pallevillesen
  • Members
  • PipPipPip
  • Advanced Member
  • 135 posts
  • LocationDenmark

Posted 19 May 2003 - 07:32 AM

Try...


$command = "UPDATE users SET password=\'$encodednewpassword\' WHERE username=\'$yourusername\' AND password=\'$encodedcurrentpass\';";



echo $command;

$sql = mysql_query($command);



if (!$sql....)


P.
Palle Villesen, www.birc.dk [br]Bioinformatics Research Center




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users