Retrieving words from database with codeigniter

I have recently started using codeigniter and I am a bit stuck as it is all rather new to me.

I use to have a config file with database conection and this on it:

$qset = "select * from re_settings";
$rset = mysql_query($qset) or die(mysql_error());
$aset = mysql_fetch_array($rset);

and this would allow me to pull words from database by simply putting this on the site

<?=$aset['SiteTitle']?>

How can I do this in codeigniter? Do I need to have a controller to do this or is it something much simpler than that.

You'll need to become familiar with the concepts of MCV which is how Codeigniter is built on and your ORM framework.

There's a bunch of helpful resources on http://tutorialcodeigniter.com/ or the official docs http://ellislab.com/codeigniter/user-guide/database/examples.html

as an example

$query = $this->db->query('SELECT name, title, email FROM my_table');

foreach ($query->result_array() as $row)
{
    echo $row['title'];
    echo $row['name'];
    echo $row['email'];
}