我有一个像下面这样的查询:
$request = $bdd->prepare('SELECT * FROM articles, cities WHERE cities.city = :current_city AND articles.idtitle = :idtitle');
$request->execute(array('current_city' => $current_city, 'idtitle' => $_GET['title']));
$data = $request->fetch();
$request->closeCursor();
但是当我尝试echo $data['ID']
时,它显示来自表城市的ID。有办法区分这两个ID吗?比如$data['articles.ID']
。
我想使用两个查询,但也许它可以完成与一个。
将查询更改为:
'SELECT articles.ID AS Article_ID,cities.ID AS City_ID,cities.*, articles.*
FROM articles, cities
WHERE cities.city = :current_city AND articles.idtitle = :idtitle'
然后在php中:
echo $data['Article_ID'];
echo $data['City_ID'];
也许用一个就可以了。
当你吃午餐的时候,你难道不会问自己同样的问题,比如它是否可以在一道菜中完成-可乐,汉堡和薯条,所有的碾碎和混合在一个碗里?