I have a table 'users' with two fields (among others) 'username' and 'password'. In this example the username is 'tester' and the password is '098f6bcd4621d373cade4e832627b4f6' (test).
This code fails:
- Code: Select all
SELECT * FROM users WHERE username='test' AND password=MD5('test');
This code succeeds:
- Code: Select all
SELECT * FROM users WHERE username='test' AND password='098f6bcd4621d373cade4e832627b4f6';
I have tried this every which way and two hours later it I have to assume that this is a XAMPP issue. If anyone has any insight PLEASE let me know.
Thanks in advance.