Why does select * from usertable where user=username and Password =
password('passowrd') not worked?
select * from usertable where user=username and password('password') does
work, but that only checks if user exists and doesn't check for the correct
password...
Any help will be greatly appreciated.
-----Original Message-----
From: Neil Zanella [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 9:39 PM
To: Jule
Cc: [EMAIL PROTECTED]
Subject: Re: password function
Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql database schema named mysql among other things.
Neil
On Sun, 12 May 2002, Jule wrote:
> Hey guys and gals,
> How do i add info to a table, and give a varchar(16) row the function of
> password, so that it is encrypted? my query now is:
> INSERT into table values('0', 'username', 'password', 'email')
>
> thanks
>
> Jule
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
