My code looks for all emails to see if $email is already in the database (that is right, because more than one user CAN NOT have the same email).
My code looks for all passwords to see if $password is already in the database (that is wrong, because more than one user CAN have the same password).
$select="SELECT * FROM area WHERE password LIKE '$password' LIMIT 1";
echo "The password is correct!";
echo "The password is incorrect!";
What is the simplest way to solve this problem?