Question

我有一个简单的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 ];
}

My problem is that I have an "id" column in both the tblhosting and tblclients tables, so my variables both have the same id. I tried to set it using an alias in the example above (ho. and cl.) but it doesn t work. How can I do this in the example above?

谢谢!

Answer 1

如何做到这一点? (a) 营地详细情况,但应当做到:


$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 ];
}

Answer 2

你们选择了这些记录,有一张野心:<条码>*>。

根据您的询问,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 ];
}

友情链接