md5 query

[aeris130]

Suppose I have the following query:

[code]SELECT * FROM users WHERE username='My_user' AND password='my_password'[/code]

Now, since my passwords are encrypted in md5, the only way to type them in like this would be to use their decrypted form. Is there any way to decrypt "my_password" before comparing it to the database?

[holowugz]

md5 are one way encryption so:


$username = $_POST['username'];
$my_password = md5($_POST['password']);

SELECT * FROM users WHERE username='$username AND password='$my_password'

[aeris130]

Ah, thanks a lot.