result_array() turns nothing but 'array' text.

[eluser]iamsen47[/eluser]
Solution here.
http://ellislab.com/forums/viewthread/223400/#1026697

Explaination?
maybe when I figure it out.


I'm trying to load some data from this table called 'prob_ref', from this col called 'ref_code' where the 'tab_code' col's value is 'APPN'. There are 5 such rows out of 73 rows.

All I get is 73 lines of the word 'Array'.

row() and row_array() returns the top most row while result() returns a "Message: Object of class stdClass could not be converted to string" error.

What am I doing wrong?

This data will eventually be used to fill out options in a dropdown menu, with the corresponding 'tab_code' for the corresponding dropdown. But I can't get anything to work. Eventually, ref_code will be the option value while ref_desc will be the option text.

model

Code:

function get_tickets($tab = FALSE)
{
  if($tab === FALSE)
  {
   $q = $this->db->select('ref_code')
        ->from('prob_ref')
        ->where('tab_code',$tab);
   return $q->get()->result_array();
  }
}

controller

Code:

public function index()
{
  $tab='APPN';
  $data['form'] = $this->form_model->get_tickets();
  
  $this->load->view('form/index', $data);

}

view

Code:

<?php foreach ($form as $form_item): ?>

&lt;?php echo $form_item?&gt;<br>

&lt;?php endforeach ?&gt;