> 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.
How do you know it "didn't work"? The first query is what you want to
use. If you are using PHP variables, make sure they actually have the
values you expect in them.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
