Dropdown from DB Alphabetized

[eluser]Michael Wales[/eluser]
Ah - it's because $this->db->get() is creating your query - you could remove your first line and it would perform exactly the same (basically, you are duplicating your efforts).

Code:

$this->db->orderby('last', 'ASC');
$query = $this->db->get('Names');

or

Code:

$query = $this->db->query('SELECT last FROM Names ORDER BY last ASC');

Not both. :-)