LoginSystem
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'), 'Test@test.de');
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.:)
Subject
Views
Written By
Posted
LoginSystem
3733
April 30, 2005 06:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.