Hi,
I think it's your problem it raise from type of field "User" from "access"
table.You try to compare some 'char' with 'bin'.
So...for this reason you must change type of the "User" field from :
User char(How_much_char_are)
to
User char(How_much_char_are) binary.
... and work fine.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Tewfic Kidess" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Tewfic Kidess" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 5:43 PM
Subject: RE: Password=password('mypassword')
> 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
