> Looks correct to me. Try running this query from the mysql program
> to verify that you're really matching the password of some entry:
>
> mysql> SELECT *, password('mypass') FROM user;
Hi guys,
I've solved the problem, but it was something related to the password
function.
In my user table, my passwd field was only set to 12 characters. It appears
that password("blah"), generates a password that is 16 characters long.
Since I was saving only the first 12 characters of the 16 char password, my
queury's "passwd = password('blah')" did not match.
What a bugger :)
Regards,
- Will
---------------------------------------------------------------------
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
