Tewfic,
Monday, May 13, 2002, 4:55:35 PM, you wrote:
TK> Hello, thanks for the suggestions so far but...
TK> mysql> select * from access where UserID='myusername' and Password =
TK> password('mypassword');
TK> Empty set (0.00 sec)
Check if your data is correct. It should work.
TK> mysql> selec
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.
ay, May 13, 2002 10:04 AM
To: Tewfic Kidess; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Password=password('mypassword')
Hi,
I think it's your problem it raise from type of field "User" from "access"
table.You try to compare some 'char' with '
"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 my
quot; <[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')
&g
7; 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: Pas
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
- 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...
>
&
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 d
