Welcome Guest, Not a member yet? Register   Sign In
Query returning string "array"
#1

[eluser]georgerobbo[/eluser]
Hello,

I am clearly doing something really stupid but I'm failing to spot it. The query returns the string "array" rather than the string inside the database table.
This is my model and controller.


Code:
<?php

class Sub_Panel_Object extends Model {

    function Sub_Panel_Object()
    {
        parent::Model();
    }
    
    function get_newsletter()
    {
        $query = $this->db->query('SELECT Object_Value FROM heal_sub_content');
        return $query->result_array();
    }
}

Code:
<?php

class Newsletter extends Controller {

    function Newsletter()
    {
        parent::Controller();    
    }
    
    function index()
    {
        $data['title'] = 'Newsletter';
        
        $data['class'] = 'newsletter';
        $data['span'] = 'Newsletter';
        
        $this->load->model('Sub_Panel_Object');
        $data['sub_panel_item'] = $this->Sub_Panel_Object->get_newsletter();
        
        $this->load->view('meta', $data);
        $this->load->view('header');
        $this->load->view('page', $data);
        $this->load->view('footer');
    }
}
#2

[eluser]n0xie[/eluser]
Change:
Code:
return $query->result_array();

To:
Code:
return $query->row_array();
#3

[eluser]georgerobbo[/eluser]
Problem is that doesn't work with my foreach() loop in my view.
#4

[eluser]georgerobbo[/eluser]
[quote author="georgerobbo" date="1251832410"]Problem is that doesn't work with my foreach() loop in my view.[/quote]

Nevermind. I forgot to define the array in my view file.




Theme © iAndrew 2016 - Forum software by © MyBB