UPDATE PROJECT
SET TEAM_LEADER = (
SELECT EMP_NO FROM EMPLOYEE WHERE FIRST_NAME = 'Mark' AND LAST_NAME = 'Guckenheimer'
)
WHERE PROJ_NAME = 'Translator upgrade';
<?php
$query = "select ProductCategory.Name Category, string_agg(SubCategory.Name, ', ') within group (order by SubCategory.Name) SubCategories
from ProductCategory
join ProductCategory SubCategory on SubCategory.ParentProductCategoryID = ProductCategory.ProductCategoryID
where ProductCategory.ParentProductCategoryID is null
group by ProductCategory.Name
order by ProductCategory.Name";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_NUM);
$columns = [];
for ($i = 0; $i < $stmt->columnCount(); $i++) {
$col = $stmt->getColumnMeta($i);
$columns[] = [
'header'=>$col['name'],
'pdo_type'=>$col['pdo_type']
];
}
echo json_encode([[
'headers' => $columns,
'data' => $rows
]],
JSON_PRETTY_PRINT
);