Hello,

I'm trying to retrieve data from a MySQL table which contains data encrypted with the 
MySQL "PASSWORD()" function from a PHP script but I can't seem to get it to work.  
Below is the query I'm trying:

SELECT * FROM user_data WHERE username = 'thaak' AND password = PASSWORD('thaak');

I then tried the following subquery/subselect:

SELECT * FROM user_data WHERE username = 'thaak' AND password IN (SELECT 
PASSWORD('thaak') FROM user_data);

...which also didn't work.

If I just execute "SELECT PASSWORD('thaak')" from the MySQL command line it returns 
the same value stored in the password column of my user_data table.  I verified these 
queries at the MySQL command line so I don't think it's a PHP problem.

I need to compare the password the user enters to log in against the password stored 
in the DB.  In addition to the "PASSWORD()" function, I also tried "MD5()" and 
"ENCRYPT()" but they also failed.  Can someone please help me accomplish this or point 
me to some resources that might help?

Thanks!

Tim Haak

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to