On Monday, 13. May 2002 15:55, Tewfic Kidess wrote: > Hello, thanks for the suggestions so far but... > > mysql> select * from access where UserID='myusername' and Password = > password('mypassword'); > Empty set (0.00 sec)
So your password is diffrent from your the password stored in your table. Try: select * from access where userid='myusername'; Then compare the value for passwd with SELECT password('mypassword'), it should be diffrent! > > mysql> select * from access where UserID='myusername' and > password('mypassword'); > returns correct result... of course this works, password('mypasswd') returns a value, so its always true. > > mysql> select * from access where UserID='myusername' and > password('wrongpassword'); > returns correct result (same result as returned in the previous select) see above Regards Georg mysql,user --------------------------------------------------------------------- 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