显示MYSQL PHP的唯一值

Question

I am trying to get the isbn number of a book from a database, but with my command it is giving me an associative array.

How do I get it to return just the isbn number in the array.

Code:

function view_all_names($db)
{
$query = "SELECT  isbn from books";

$statement = $db->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$statement->closeCursor();
return $result;      

}

Answer 1

If $db is a PDO object you can use

$result = $statement->fetchAll(PDO::FETCH_COLUMN);

PDOStatement::fetchAll