当我通过PHP PDO语句选择MySQL中的多个表时
$query = "SELECT * from offers, courts";
如何输出重复的字段名?例如,在每个表
中存在以下字段offers.description and courts.description
当我执行while/foreach循环遍历键时,我只能输出如下内容
$row['caption']
我需要这样的东西
$row['courts.caption'] or $row['courts']['caption']
我该怎么做呢?
您可以选择如下字段:
$query = "SELECT o.description as OfferDescription, c.description as CourtsDescription from offers o, courts c";
然后使用:$row['OfferDescription']
OR $row['CourtsDescription']