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
> 
> The query didn't return any rows when the only row in the table
matched
> the criteria.  Someone else suggested adjusting the field width in the
> table which worked.  I didn't think the PASSWORD() function added that
> many additional characters (5 character password resulted in a string
> longer than 15).  The stored string's end was concatenated.  I found
that
> in my example it made the string 4 times as long.
> 
> Thanks!
> 
> Tim Haak
> 
> -----Original Message-----
> From: John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 10, 2002 7:17 PM
> To: Tim Haak; [EMAIL PROTECTED]
> Subject: RE: [PHP-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' 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




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to