[PHP-DB] password---simple questions but...

[Hadi]

Hi, all
please help me in this, Iam using MYSQL , my colomn is password varchar(12)

insert into tablepassword values ('',password('def'));

it is executed, (select * from tablepassword) showing the password is
hashed, and then to view the record using 'where' :

select * from tablepassword where password=password('def');
display empty set, how to solve this?
Thanks in advance.


Merry Christmas and Happy New Year
Hadi Tjen

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

Re: [PHP-DB] password---simple questions but...

[John W. Holmes]

Hadi wrote:

Hi, all
please help me in this, Iam using MYSQL , my colomn is password varchar(12)

insert into tablepassword values ('',password('def'));
PASSWORD() always returns a result that's 16 characters. So you should 
be using a VARCHAR(16) column.

--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals  www.phparch.com

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