Dropdown from DB Alphabetized

[eluser]Michael Wales[/eluser]
Ah - I think what you are wanting is it to load, by default - "Select Client" then people click that to select whatever client they want? That's easy.

Code:

$data['Names']['default'] = '--Select Client--';
$this->db->query('SELECT last FROM Names ORDER BY last ASC');
$query = $this->db->get('Names');
foreach ($query->result() as $row){
     $data['Names'] [$row->last] = $row->last;
}

//LOAD  VIEW AND DATA FOOL
$this->load->view('index_view', $data);

Code:

$formAtt = array('id'=>'selClient');
echo form_open('selectClient', $formAtt);
$js = 'onChange = alert(document.selClient.clients.options[document.selClient.clients.selectedIndex].value)';
echo form_dropdown('clients', $Names, 'default', $js);
echo form_close();