Passwords Re: Authentication

[Micah Yoder <LYoder@cyberis.net>]

> > > Also, I still haven't figured out how to check passwords with MySQL.  I
> > > haven't looked much since the last time I asked.  But if someone has
> > > some code, that would be great.
> 
> What do you mean by check passwords?  If you were verifying a users
> password you would do something like this:
> 
> select Password from Users where Handle = '<? echo handle ?>';
> 
> and then compare password(what user enters) to the Password returnerd by
> the query (without passing it thru the password() function.

But that doesn't seem to work.  select Passwd just returns the encrypted
password.  Password doesn't exist.  And the password hash != the crypt()
function, right?