create table categories (
id int primary key,
name varchar(64)
);
insert into categories values (1, 'Technology');
create table products (
id int primary key,
category_id int references categories(id),
name varchar(64),
index(id)
);
insert into products values (1, 1, 'Monitor');
<?php
$query = "
SELECT
p.name AS product, c.name AS category
FROM products p
JOIN categories c ON c.id = p.category_id;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
printf('| product name | category |' . PHP_EOL);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
printf('| %-12s | %10s |' . PHP_EOL, $row['product'], $row['category']);
}