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