Hi there,

I want to use a database output in a dropdown box but can’t do the magic with array’s.
how dos that work?

I have this in the controler:

$sql = “SELECT inst_id, inst_rument”
. “\nFROM instr”
. “\nORDER BY inst_rument”;
$query = $this->db->query($sql);

// DATA ARRAY
$data = array(

// laden queries,
‘query’=>  $query
);

$this->load->view(‘page’, $data);
</php>

And this code to load the array in de view file

<? echo form_dropdown(‘instrumenten’, $query); ?>

and i used:

<? echo form_dropdown(‘instrumenten’, $query->result_array()); ?>

I get the dropdown list but only showing array or object.

How to do this?

thanks!

To begin with, I don’t think you need those \n characters in your SQL query - just have it all on one line. Next, you need to supply the results to the view (not the query) using result_array() as detailed on this page in the User Guide. Your code should then look like this:

Yes i tried that…

and now again but that dosn’t work either.
i dont get results that way.

Now i just don’t use the form helper but i would like to kno how to use it.

Thank though.