>我有一个简单的JOIN查询:
$lstCheck = $dbWHMCS->query('SELECT * FROM tblmonitorports mp
INNER JOIN tblmonitorhosts h ON h.hst_id = port_mon
INNER JOIN tblhosting ho ON ho.id = h.hst_serverid
INNER JOIN tblclients cl ON cl.id = ho.userid');
while ($data = $lstCheck->fetch())
{
$serveridx = $data['ho.id'];
$clientid = $data['cl.id'];
}
我的问题是我在 tblhosting 和 tblclients 表中都有一个"id"列,所以我的变量都有相同的 id。我尝试使用上面示例中的别名(ho. 和 cl.)设置它,但它不起作用。在上面的示例中,我该如何执行此操作?
谢谢!
这个怎么样?(在PHP细节上有点生疏,但这应该可以做到):
$lstCheck = $dbWHMCS->query('SELECT ho.id hid, cl.id cid FROM tblmonitorports mp
INNER JOIN tblmonitorhosts h ON h.hst_id = port_mon
INNER JOIN tblhosting ho ON ho.id = h.hst_serverid
INNER JOIN tblclients cl ON cl.id = ho.userid');
while ($data = $lstCheck->fetch())
{
$serveridx = $data['hid'];
$clientid = $data['cid'];
}
您正在选择带有通配符*
的记录,因此您无法选择这样的字段。
根据您的查询,h.hst_serverid
& ho.userid
具有与您想要的完全相同的值。所以简单地这样做
while ($data = $lstCheck->fetch())
{
$serveridx = $data['hst_serverid'];
$clientid = $data['userid'];
}
但是,选择特定行听起来也更好
$lstCheck = $dbWHMCS->query('SELECT ho.id hid, cl.id cid, ....');
while ($data = $lstCheck->fetch())
{
$serveridx = $data['hid'];
$clientid = $data['cid'];
}