how to output MySQL query results?

[eluser]Tony W[/eluser]
In my controller, I have the following code:

Code:

$query = $this->db->query("SELECT example FROM slang WHERE `slang` =' $slang_input' ");
    

      
      foreach ($query->result() as $row)
      {
        echo $row->example;
      }

I wonder how to output the $row->example better? There might be lots of results for this query, maybe I should make it an array and pass it to the view file?

thanks