Re: MySQL Password Encryption

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