php - PDO:: Confusion -


i have no idea why not returning anything. i'll show code , talk through steps i've taken.

if (isset($_get['observation'])) {     require_once("../func/connect.php");     $query = "select * observations option = ?";     $stmt = $db->prepare($query);     $stmt->bindvalue(1, $_get['observation']);     $stmt->execute();      $row = $stmt->fetch(pdo::fetch_assoc);     echo $row['question'];  } else {     echo 'nope'; } 

$row dumps false boolean, $row['question'] null.

i've wrote million queries , don't have clue why doesn't work.

database table observations consists of id, question & option , bindvalue correct match string in database.

however, returns null.

option reserved word in mysql need quote backticks:

$query = "select * observations `option` = ?"; 

Comments