warlock 999
New Member
I have a simple JOIN query:\[code\]$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 = http://stackoverflow.com/questions/10545066/$lstCheck->fetch()){ $serveridx = $data['ho.id']; $clientid = $data['cl.id'];}\[/code\]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?Thank you!