在SQL查询中使用表名时如何访问PDO结果？

Question

I recently had to change an SQL query to query multiple tables and started specifying the table names with the column names.

$results = $db->query('SELECT categories.name, channels.description, channels.name FROM categories JOIN channels ON categories.id = channels.category ORDER BY RANDOM() LIMIT 4');

However now I have a problem that the rest of the code doesn't work even though I updated it to use the table names with the column names.

<h3><?php echo $row['channels.name']; ?></h3>

How do I specify table name with column names in this way? The SQL query itself is fine but I don't understand how to echo the results?

Answer 1

The table name is unlikely to carry through to the output. Instead, alter the name of one of the columns with an alias, such as:

$results = $db->query('SELECT categories.name as cat_name, channels.description, channels.name FROM categories JOIN channels ON categories.id = channels.category ORDER BY RANDOM() LIMIT 4');

Then when referencing the columns, you refer to

<h3><?php echo $row['name']; ?></h3>
<h3><?php echo $row['cat_name']; ?></h3>

Etcetera.