Same Password Not Matching Encrypted Database Password

[ATM]

Ok, I'm creating a login system and I have the users passwords saved in a database. However the passwords in the database are encrypted using the password encryption included with mysql.When I compare the password the user submitted, with the encrypted password on the database they do not match.Is there anyway I can stop this from happening, I'm using php by the way.Thank You.

[pulpfiction]

problem might be in method to comparision password submitted be user......Which encryption function are you using? like md5() or sha1().....? it might help if you can post the SQL query used...

[ATM]

I'm not really sure, I'm using phpmyadmin and there is a 'PASSWORD' option.The method I'm using to compare them is a simple if statement.Thank you,

[jlhaslip]

Before you check the value of the submitted password to the one stored in the database, you will need to hash or encrypt the value similarly to the method used prior to storing it or they won't be the same. And the comparison will prove false, so the page will reject the user. Security can be just like that some times.