--TEST-- PDO Common: PDO::FETCH_UNIQUE --SKIPIF-- --FILE-- exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); $db->exec("INSERT INTO test VALUES('A', 'A')"); $db->exec("INSERT INTO test VALUES('B', 'A')"); $db->exec("INSERT INTO test VALUES('C', 'C')"); $stmt = $db->prepare('SELECT id, val from test'); $stmt->execute(); var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE)); $stmt->execute(); var_dump($stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE)); ?> --EXPECT-- array(3) { ["A"]=> array(1) { [0]=> string(1) "A" } ["B"]=> array(1) { [0]=> string(1) "A" } ["C"]=> array(1) { [0]=> string(1) "C" } } array(3) { ["A"]=> array(1) { ["val"]=> string(1) "A" } ["B"]=> array(1) { ["val"]=> string(1) "A" } ["C"]=> array(1) { ["val"]=> string(1) "C" } }