> 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,
I think the problem goes here:
> PHP4> $result = mysql_query("insert into user values ('$username',
> password('$password'), '$email')");
Please ensure $password is correct, and with no problem..
( eg. space/ at the enter of the string ... etc.. )
--
At 9:30 PM -0400 6/16/01, William Wong wrote:
> > >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
> >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
At 8:49 PM -0400 6/16/01, William Wong wrote:
>Hi there,
>
>For some reason, this query doesn't work:
>
>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?
>
>WHILE this
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 = "
