how to output MySQL query results?

[eluser]mironcho[/eluser]
In the DB class already exists result_array() method, so you can do:

Code:

$ret = array();

$query = $this->db->query("SELECT example FROM slang WHERE `slang` =' $slang_input' ");
if ($query->num_rows() > 0)
{
    // use result() for array of objects
    // $ret = $query->result();

    // use result_array() for array of arrays
    $ret = $query->result_array();
}

return $ret;

and then loop through it in your view.