LoginSystem

[Rouven Lange]

Hi,

iam working on a loginsystem with PHP.
But i have some problems.
i have a database with User,Passwd, Email and so on.
The Passwd is MD5Encrypted ("MD5('test')").
So but when iam going to check the password for the login, it is not going to work.

This is my:

SQL SCRIPT for inserting:

INSERT INTO USER(User,Passwd,Email) VALUES ('TEst', MD5('test'), '[e-mail]');

DATABASE:
----------------------------
| User | Passwd | Email |
----------------------------
| Test | 098f6... | test... |
----------------------------

SCRIPT FOR CHECKING:

SELECT * FROM User WHERE passwd = MD5('$test')

But he says that he cant find any Value with MD5('test').

Iam using MYSQL 5.0
THx
and Sorry for my crappy englisch.:)