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
-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
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
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