Login query

[Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx>]

I am wondering what others do for a login query.  I think there could be
two results: correct e-mail & password; correct e-mail & wrong password

So far my login query is:

SELECT * FROM `member` WHERE `email` = '$my_email' AND `pass` LIKE
BINARY '$my_password' LIMIT 1

This wouldn't tell me if the user has the wrong password.  Is there a
better way to do this?

Ron