When using passwords, I always use MD5 encryption, and I add a special string...
For example, if the password is "1234567", I will add a constant string, let's say "tomorrowisnewyear_", so the result is "tomorrowisnewyear_1234567", and then MD5()-it : 50bd081721a77abe6cd752df60608146
So when checking the password...
Sent password = 1234567
MD5 string to be checked : MD5('tomorrowisnewyear_1234567')
Does that encrypted string equal the one stored in the DB ?