Try using: mysql> select * from fc_Customer where User_Password='abcd';
At 12:21 PM 5/8/2003 -0600, you wrote:
Hi,
I was wondering if I could get some MySQL help for the PHP file I'm writing. I'm using the password command to encrypt my passwords in MySQL. Here is a simple line:
mysql> insert into fc_Customer (User_Password) values(password("abcd")); Query OK, 1 row affected (0.00 sec)
However, when I try to select the line by searching on the password here is the response:
mysql> select * from fc_Customer where User_Password=password("abcd"); Empty set (0.00 sec)
I can view see that the record was added and that the password was encrypted, but I can't compare it or select it using password function.
Can someone please help.
Thanks!!!
Doug Coning
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Jadiel Flores ------------------------- http://www.abargon.com jflores@abargon.com (52-55) 52-29-80-34
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
