title: Convert inner join value to String - CodeIgniter
body: <p>I am working in a school project using some CodeIgniter and I had a little problem while making a view. </p>
  
  <p>Basically, I need to print a column value in the screen and, in order to get this value, I had to use an inner join. </p>
  
  <pre><code>form_label($this-&gt;db-&gt;query("SELECT DISTINCT(MATERIA.NOME) FROM MATERIA INNER JOIN TURMA_has_MATERIA ON 
                              TURMA_has_MATERIA.MATERIA_idMATERIA = MATERIA.idMATERIA
                              WHERE MATERIA.idMATERIA = " . $thm-&gt;MATERIA_idMATERIA), "txt_1i")
  </code></pre>
  
  <p>The query works just fine when I use it in phpMyAdmin but it returns an array when used in a CodeIgniter view, resulting in an error. Is there any function that could help me to convert this value to something that could be printed? Thank you.</p>