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> select * from access where UserID='myusername' and
TK> password('mypassword');
TK> returns correct result...
TK> mysql> select * from access where UserID='myusername' and
TK> password('wrongpassword');
TK> returns correct result (same result as returned in the previous select)
Yes, because password('some_value') gives you TRUE in WHERE clause.
TK> which brings me to the realization that:
TK> select * from access where UserID='myusername' and password('mypassword');
TK> does not work! it's not checking for the correct password
TK> Any and all help will be greatly appreciated.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
