sha1 problems

[OniLink]

Hi,

When I use the SQL:

$sql = 'SELECT user_id FROM users WHERE username = "'.$POST['username'].'" AND password = "'.sha1($POST['pwd']).'"';

It doesn't return anything, even though I have purposly made the passwords the same. I did an echo on the password in the database and then did an echo on the $_POST['pwd'] using the sha1 method again. The results were different, even though they were both originally the same password...

Can someone please help?

Thanks,
~Oni.

[laserlight]

The results were different, even though they were both originally the same password...

That's not possible. Are you sure you used sha1() on the passwords when storing into the database? If you used the database engine's implementation of SHA1, the results could (but should not) be different.