how is convert this code to CodeIgniter code?

[eluser]Mat-Moo[/eluser]
Your mixing "Active records" with basic sql, you need something more like

Code:

foreach ($result->result() as $row)
{
    $data[] = array('name' => $row->name)
}

Something like that anyway

http://ellislab.com/codeigniter/user-gui...ecord.html
First section on the get() has a better example