actually, the access table is a table that i've created, in a different database than mysql, that holds usernames and passwords for a site that i'm working on. It has nothing to do with user table of mysql database.
-----Original Message----- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:43 AM To: Tewfic Kidess; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Password=password('mypassword') Hi, "access" table it's your table or you make reference to the mysql.user table ? Regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "Tewfic Kidess" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 4:55 PM Subject: RE: Password=password('mypassword') > Hello, thanks for the suggestions so far but... > > Empty set (0.00 sec) > > mysql> select * from access where UserID='myusername' and > password('mypassword'); > returns correct result... > > mysql> select * from access where UserID='myusername' and > password('wrongpassword'); > returns correct result (same result as returned in the previous select) > > which brings me to the realization that: > select * from access where UserID='myusername' and password('mypassword'); > does not work! it's not checking for the correct password > > Any and all help will be greatly appreciated. > > -----Original Message----- > From: Georg Richter [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 12, 2002 11:58 PM > To: [EMAIL PROTECTED] > Subject: Re: Password=password('mypassword') > > > Hi, > > > Why does select * from usertable where user=username and Password = > > password('passowrd') not worked? > > > > You should quote the username, and fix the typo in 'passowrd'. > > 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... > > Same here, quote the username and set the Password field in the where > clause. > > Regards > > Georg > > mysql,query > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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