Echoing results from a database

[eluser]Thorpe Obazee[/eluser]
http://ellislab.com/codeigniter/user-gui...sults.html

Code:

$query = $this->db->query("YOUR QUERY");

foreach ($query->result() as $row)
{
   echo $row->title;
   echo $row->name;
   echo $row->body;
}

You should return the query result first then loop through it and then that's when you echo.