Re: username and password validation!

If you are using password() to validate the password when a user is logging in, you should have also used password() when you created the password in the database. Once you convert the password using password() you can't change it back. You have to use password() everytime to check it. Hope this helps, -- Nicole Amashta Web Application Developer www.aeontrek.com "Nik Alleyne" <nik@guyanachronicle.com> wrote in message news:20020423001814.8666.qmail@pb1.pair.com... > Hi there everyone, > my problem should b simple. > > Problem: > I am trying to validate a username and password though HTML forms. The > thing is when i encrypt the password using mysql password encryption > function 'PASSWORD()' and try to validate the password I am getting the > error message that I've set for when the username and/or password is > invalid. However, if I do not encrypt the password, i am validating quite > easily. > > can someone please help; > > Thankx > Nik > >