I get error on this code.. I set UserName and Password but i get error. What is the my fail ?
$Id=$db->prepare("select UserID from Users where 1=1 and IsActive=1 and Name=:UserName and Password=:Password");
$Id->bindParam(":UserName",$UserName,PDO::PARAM_STR);
$Id->bindParam(":Password",$Password,PDO::PARAM_STR);
$Id->execute();
This is error:
PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens