Login query
| From: | Ron Piggott | Date: | Thu, 18 Feb 2010 21:40:38 +0000 |
| Subject: | Login query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46900@lists.php.net to get a copy of this message | ||
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