Storing MS Access Passwords

[liquidchild]

I am storing password for my site users in a MS Access database,
however when I run the following query it does not return anything:

SELECT p.privilege, e.firstname
FROM T_Login AS l, T_Privilege AS p, T_Employee AS e
WHERE l.username = 'aca' AND l.password = 'c6d6bd7ebf806f43c76acc3681703b81' AND l.privilege_id = p.privilege_id AND l.username = e.username;

The password is stored using MD5 format.

Any suggestions?

[lush_pierre]

You may well have something like the password wrong. The query looks ok as long as the joins are correct. I suggest trying the sql directly and seeing if you get any results.
If not, try removing the joins and just getting something back from your login table. If you can't do a simple select from this table your password or name must be wrong.

Oh, another thing, why not use md5 instead of typing in the password as a test:

.....AND l.password = ' " . md5($password) . " ' AND l.privilege_id .........

Pete.