如何在SQL中打印表名包含对象的行？

Question

How do I print rows where table names contains object, here printing of 'A.arrival' is not happening.

echo "arrival :" .$row['A.arrival'] ."."

Answer 1

Most database APIs don't include the table name in the associative array keys. So you should just use $row['arrival'].

If your query is returning two arrival columns from different tables, you should give one or both of them a different alias, e.g.

SELECT a.arrival AS a_arrival, b.arrival AS b_arrival, ...

Then you can refer to them as $row['a_arrival'] and $row['b_arrival'].