I have created a MY_Controller and I'm linking to it through my main controller... I am now trying to create a settings function which will get all the results from a database and return the one you want... The only problem I'm having is being able to do using the template engine...
protected function settings()
{
// select all settings from database
$query = $this->db->query('SELECT * FROM settings');
// get result from database
$this->data['settings'] = $query->result_array();
// return array of data
return $this->data['settings'];
}
How can i go about this?
The only way I can access it at the moment is:
{settings}
{name}
{value}
{/settings}
P.S. I call the function $this->settings()
in the __construct() function also I forgot to mention I'm using codeigniter