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
