Okay, here's a hint... 4.2.9 in the manual (;o)
Basically, if you encrypt the password, then you have to look it up using the password function, too. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949-7261 -----Original Message----- From: Ramiro Varandas Jr [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: Password function I think that this question might be kinda of stupid for all of you but I couldn't find a good answer... When we use the MySQL internal function - Password('string') - MySQL inserts that string codified into the database, so that people that look for that doesn't know the real password. But i have a client that have a website and in the table of customers I'd like to use that function to make it more secure, but when I do that, I can't authenticate the user anymore, because if i write: SELECT user_id FROM user WHERE user_pass = 'my_var' It doesn't return me a user... but it's there, registered... Is there a way to do that or no... if there is, something give me a hint... My client's website is running in a Windows 2000 server but the MySQL server is runnig in a linux machine. Regards, Ramiro Jr. --------------------------------------------------------------------- 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