title: Issue Retrieving results from SQL query in PHP
body: <p>My code performs an <code>SQL</code> Query as shown below:</p>
  
  <pre><code>$query = 'SELECT 
          cl.*,c.id,c.type,c.firstname,c.surname,c.job,c.company,c.directorycompany_id, dc.id, dc.name, es.id, GROUP_CONCAT(dirc.name), GROUP_CONCAT(dirp.name), GROUP_CONCAT(dirs.name) 
          FROM contactlist_contact cl '.
          'INNER JOIN contact c ON cl.contact_id = c.id '.
          'LEFT JOIN directorycompany dc ON dc.id = c.directorycompany_id '.
          'LEFT JOIN expertsection es ON es.id = c.expertsection_id '.
          'LEFT JOIN directorycolumn dirc ON dirc.directorycontact_id = c.id '.
          'LEFT JOIN directoryprogramme dirp ON dirp.directorycontact_id = c.id '.
          'LEFT JOIN directorysupplement dirs ON dirs.directorycontact_id = c.id '.
          'WHERE cl.contactlist_id = '.$contactListId.' ORDER BY dc.surname';
  
  $db-&gt;query($query,$t);
  </code></pre>
  
  <p>I attempt to retrieve the contents of the results returned as shown:</p>
  
  <pre><code>while($db-&gt;next($t))
  {
      $contact = new DirectoryContact(0);
      $contact-&gt;setId($db-&gt;get('c.id',$t));
      $contact-&gt;setContactType($db-&gt;get('c.type',$t));
      $contact-&gt;setFirstname($db-&gt;get('c.firstname',$t));
      $contact-&gt;setSurname($db-&gt;get('c.surname',$t));
      $contact-&gt;setJob($db-&gt;get('c.job',$t));
      $contact-&gt;setCompany($db-&gt;get('c.company',$t));
      $contact-&gt;setDisplayColumn($db-&gt;get('GROUP_CONCAT(dirc.name)', $t));
      $contact-&gt;setDisplaySupplement($db-&gt;get('GROUP_CONCAT(dirs.name)', $t));
      $contact-&gt;setDisplayProgramme($db-&gt;get('dirp.name', $t));
  
      $directoryCompany = new DirectoryCompany(0);
      $directoryCompany-&gt;setId($db-&gt;get('dc.id',$t));
      $directoryCompany-&gt;setName($db-&gt;get('dc.name',$t));
  
      $expertSection = new ExpertSection(0);
      $expertSection-&gt;setId($db-&gt;get('es.id',$t));
  
      $contact-&gt;setDirectoryCompany($directoryCompany);
      $contact-&gt;setExpertSection($expertSection);
  
      $this-&gt;contacts-&gt;add($contact);
  }
  </code></pre>
  
  <p>For some reason, every time, these lines are returning <code>false</code>.</p>
  
  <pre><code>$contact-&gt;setDisplayColumn($db-&gt;get('GROUP_CONCAT(dirc.name)', $t));
  $contact-&gt;setDisplaySupplement($db-&gt;get('GROUP_CONCAT(dirs.name)', $t));
  $contact-&gt;setDisplayProgramme($db-&gt;get('GROUP_CONCAT(dirp.name)', $t));
  </code></pre>
  
  <p>Does anybody know where I am going wrong? Many thanks.</p>