So far no luck with deciphering the Syntax error.
So I decided to test the encrypted password on an existing table where I added a new PW field: sa_password and then I updated a record with an encrypted password.
Using the same log-in page with the same MySQli authentication code and which I also changed the input form field name from member_password to sa_password
This code works using the password as pure text:
$Authenticate->addFilter("member_email", "=", "s", "".((isset($_POST["member_email"]))?$_POST["member_email"]:"") ."");
$Authenticate->addFilter("member_password", "=", "s", "".((isset($_POST["member_password"]))?$_POST["member_password"]:"") ."");
but this code using the new encrypted password does not:
$Authenticate->addFilter("member_email", "=", "s", "".((isset($_POST["member_email"]))?$_POST["member_email"]:"") ."");
$Authenticate->addFilter("sa_password", "=", "s", "".((isset($_POST["sa_password"]))?$_POST["sa_password"]:"") ."");
Does something else need to be changed in order for the encrypted password to be recognized?