Login: SHA1/MD5 passwords don't match

I'm trying to create a User Login on my website using php/mySQL. When I create a new user, I send the password as a MD5 hash to my database. The problem is, when I try to login with the same password (again, hashed using MD5), the passwords don't match.

Here is my SQL code:
for createUser.php:

Code:

INSERT INTO `Users` (`UserLogin`, `UserPass`)
VALUES ('name', MD5('pwd'))

for login.php

Code:

SELECT *
FROM `Users`
WHERE `UserLogin` = 'name' AND `UserPass` = MD5('pwd')

I have tried entering this code directly into phpMyAdmin, with no results -- so it isn't a problem with my php code. I have also tried using SHA1 hashing.

What am I doing wrong?

Hi,

the only reason I can imagine is that the `UserPass` column is not big enough to hold the hash.

For example if the is hash is 1234 but your column can only hold 123, the next time you'll compare the generated hash 1234 with 123 it won't match.

If changing that doesn't help, post your table structure.

Destructive

the only reason I can imagine is that the `UserPass` column is not big enough to hold the hash

Thanks, Destructive! That was exactly it. My UserPass was set as INT(16), and needed to be at least INT(32) to hold the hashed password.

You're welcome. I'm glad I could help you.

[Guest]

[62.814]

Googlebot, jackandrew, Yahoo crawler