I'm attempting to run this straightforward Choose query using PDO::MySQL, but it doesn't return something, as you can tell in the dump $row returns false, meaning there is a mistake.

The database connection works, as I am conntacting the database a couple of lines further lower

Sql totally correct

Can someone begin to see the bug within this code? If you're able to I'd really be thankful, because this continues to be annoying me for hrs


$statement = $DbConn->prepare("SELECT id FROM mineral_index WHERE typeID = :typeID AND systemID = :systemID");
$statement->bindParam('typeID', $this->typeID, PDO::PARAM_INT);
$statement->bindParam('systemID', $this->systemID, PDO::PARAM_INT);
$row = $statement->fetchObject();

echo "<p><pre>";
$statement->debugDumpParams();
var_dump($statement->errorInfo());
var_dump($this->typeID);
var_dump($this->systemID);
var_dump($row);
echo "</pre></p>"; 

dump:


SQL: [76] SELECT id FROM mineral_index WHERE typeID = :typeID AND systemID = :systemID
Params:  2
Key: Name: [7] :typeID
paramno=-1
name=[7] ":typeID"
is_param=1
param_type=1
Key: Name: [9] :systemID
paramno=-1
name=[9] ":systemID"
is_param=1
param_type=1
array(3) {
  [0]=>
  string(5) "00000"
  [1]=>
  NULL
  [2]=>
  NULL
}
int(35)
int(30000142)
bool(false)

$statement->execute() ?????