> 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,
> >PHP4> mysql_query("select * from user where username='myname' and passwd
=
> >password('mypass')");
>
> Define "doesn't work". Fails to return rows? PHP generates an error
>message?
Hi Paul,
Sorry bout that. Yes it doesn't return any rows despite the fact that the
correct username and pass
Hi there,
For some reason, this query doesn't work:
PHP4> mysql_query("select * from user where username='myname' and passwd =
password('mypass')");
WHILE this one does work:
PHP4> mysql_query("select * from user where username='myname' and
password('mypass')");
Notice the lack of "passwd = "
