On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote: > INSERT into tbl_name (username,password) values > ('user',PASSWORD('passwd')); > > and when authenticating the user you can do something like > > SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this > case $pass is the variable holding the password entered on the webpage.
NEVER use the PASSWORD() function! It is totally insecure and still in MySQL in historical reasons. Use function MD5() instead. Tõnu --------------------------------------------------------------------- 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