Array into view

[eluser]piotrjanczak[/eluser]
So...
My Model:

Code:

public function func_name()
    {
        $query = $this->db->query('SELECT login, email FROM users');
        if ($query->num_rows() > 0)
        {
            return $query->result_array();
        }
        else
        {
            return 0;
        }
    }

My Controler

Code:

$this->load->model('model');

$data = $this->model->func_name();
print_r($data);

$this->load->view('my_view', $data);

print_r($data) give me somethink like that:

Array (
[0] => Array ( [login] => john [email] => [email protected] )
[1] => Array ( [login] => bob [email] => [email protected] )
[2] => Array ( [login] => martin [email] => [email protected] )

My View

Code:

echo '
<table>
<tr>
<td>Login</td>
<td>Email</td>
</tr>';
foreach ($_WHAT as $item) {
echo '
<tr>
<td>' . $_ITEM_LOGIN_WHAT . '</td>
<td>' . $_ITEM_EMAIL_WHAT . '</td>
</tr>';
}
</table>

My questions: what i must supplement instead of $_WHAT, $_ITEM_LOGIN_WHAT, $_ITEM_EMAIL_WHAT (or what i do wrong?) ?

[eluser]toopay[/eluser]
If you auto load array helper, you can do this way,
in controller :

Code:

...
$users = $this->model->func_name();
$data = array(
      'total'   => count($user),
      'users'   => $users,
);
$this->load->view('my_view', $data);
...

then in view :

Code:

...
echo '
<table>
<tr>
<td>Login</td>
<td>Email</td>
</tr>';
foreach ($users as $user) {
echo '
<tr>
<td>' . element('login', $user) . '</td>
<td>' . element('email', $user) . '</td>
</tr>';
}
</table>
...

[eluser]piotrjanczak[/eluser]
It work's!
Thanx!

// Edit

For future generation... I change func_name():

Code:

public function func_name()
    {
        $query = $this->db->query('SELECT login, email FROM users');
        return $query->result_array();
    }

It work's everytime... when query return 0 or more records...

[eluser]InsiteFX[/eluser]

Code:

// instead of this
return 0;

// use this
return FALSE;