making a select dropdown from database in codeigniter [closed]

In your controller you are passing value like

$data['red']=$this->mymodel->get_sec_info(); 

and in you view you are taking value like

<?php foreach($rec as $row) {?> 

So change the vairiable $rec to $red in your view like

<?php foreach($red as $row) {?> 

Your option tag is badly formed. The opening option tag is missing its closing bracket, and the closing quotation mark for the option tag's value is in the wrong place.

Corrected:

<option value="<?php echo $row->sec_id?>"><?php echo $row->name ?></option> 

You should use CI form helper function instead of using html code

In model

 function get_sec_info() { $records=$this->db->query('SELECT sec_id,name FROM section'); $ret_arr = array(); if($records->num_rows() > 0) { while($records->result() as $r) $ret_arr[$r->sec_id] = $r->name; } return $records->result(); } 

In your view

echo form_dropdown("section",$rec); 

Remove your code below in view:

<select name="section"> <?php foreach($rec as $row) {?> <option value="<?php echo $row->sec_id?>"><?php echo $row->name ?></option>" <?php } ?> 

Make sure you have loaded form helper.