display unique values from 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.
Here is my code

function view_all_names($db)

{

$query = "SELECT  isbn from books";



$statement = $db->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

$statement->closeCursor();

return $result;      



}

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

If $db is a PDO object you can use

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

PDOStatement::fetchAll

display unique values from MYSQL PHP

Sign up