RE: [PHP-DB] Selecting PASSWORD() value in MySQL

2002-10-11 Thread John W. Holmes
PASSWORD() always returns a string that's 16 characters long. ---John Holmes... -Original Message- From: Tim Haak [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 8:05 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Selecting PASSWORD() value in MySQL

RE: [PHP-DB] Selecting PASSWORD() value in MySQL

2002-10-11 Thread Tim Haak
-DB] Selecting PASSWORD() value in MySQL 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

[PHP-DB] Selecting PASSWORD() value in MySQL

2002-10-10 Thread Tim Haak
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

RE: [PHP-DB] Selecting PASSWORD() value in MySQL

2002-10-10 Thread John W. Holmes
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