title: Set variable from alias in SQL query
body: <p>I have a simple JOIN query:</p>
  
  <pre><code>$lstCheck = $dbWHMCS-&gt;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-&gt;fetch())
  {
              $serveridx = $data['ho.id'];
              $clientid = $data['cl.id'];
  }
  </code></pre>
  
  <p>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?</p>
  
  <p>Thank you!</p>