Search code examples
phppdoexecute

$sth->execute() returning false

I have this code:

$dbh = new PDO("mysql:host=$dbHost;dbname=$dbName", $dbUser, $dbPassword);
$sth = $dbh->prepare(" SELECT `login`, `password` FROM `admins` WHERE `login` = ?, `password` = ? ");
var_dump($sth->bindParam(1, $login)); // true
var_dump($sth->bindParam(2, $password)); // true
var_dump($sth->execute()); // false
Solution 
  • WHERE `login` = ?, `password` = ?

    shouldn't that be...

    WHERE `login` = ? and `password` = ?