... work fine with:
mysql> select * from access where UserID='myusername' and
password=password('mypassword');
----- 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
