$db->Sql ("SELECT * FROM Staff");
$hit=0;
while ($db->FetchRow())
{	
  my(%record) = $db->DataHash();	
  if ($FORM{'name'} eq $record{'login'} && $FORM    {'password'} eq $record{'password'}) 

{			
$hit=1;
			
if ($FORM{'newpassword'} eq $FORM{'confirmpassword'})
{

-------------------------------				
PROBLEM 

#$sql = qq{INSERT INTO Dreamcpu(FirstName, LastName, Address, Email, Ph +one, Username, Password) VALUES ('$first', '$last', '$adress', '$emai +l','$phone', '$user', '$pass');}; 

#$sqlupdate = qq {UPDATE staff SET password=$FORM WHERE $FORM{'user'} LIKE $record{'login'}";

my $query = "UPDATE staff SET password=$FORM{'newpassword'} WHERE $FORM={'name'} eq $record{'login'}";

#$dbh->do (qq{ UPDATE `staff` SET `password` = $FORM{'newpassword'}})";

$dbh->do(sqlupdate);
$db->close();
----------------------------
#OK PASSWORD CHANGED

}
else
{
#Please Use Your Browsers Back Button To Re-Enter	
$db->Close();
				
}			
	
} 	  		
}
if ($hit ne 1)
{
#logs error logouts.
		   
		
#COULD NOT FIND LOGIN NAME!;
Please Use Your Browsers Back Button & Re-Enter;
}
	
#close the connection to the database end the html page.
$db->Close();