password update problem with md5

[sbettadpur]

hello,


I am getting some problem while updating password field in my application.

let me explain briefly i have table called "A" in that i have two fields Recruiter_Name and Confm_Passwd. if i want to update Recruiter_Name and Confm_Passwd its not updating.

the query i am using for updation is
[code=mysql]
UPDATE recruiter_profi le
SET Recruiter_Name= 'ravish'
AND Confm_Passwd=md 5('ravish')
WHERE Emp_Code='18';
[/code]
If i remove Confm_Passwd=md 5('ravish') it will work.

[Atli]

Hi.

Are you getting any errors?
What type of field is the password field?

Also, please use [code] tags when posting your code / queries.