Login query

[email protected] (Ron Piggott) Thu, 18 Feb 2010 16:40:38 -0500

Newsgroups	php.db
Organization	Acts Ministries Christian Evangelism
Message-ID	<[email protected]>

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