[HELP] sql depends to another sql

[eluser]InsiteFX[/eluser]
Load your model in the controllers constructor.

Code:

// controller
$data['querys'] = $this->model_name->ambil_data_users($id);
$this->load->view('view_name', $data);

// model
function ambil_data_users($id)
{
return $this->db->query("select * from transaksi_users where id_users = '$id'")->result();
}

// view
<?php foreach($querys as $row): ?>
    &lt;?php echo "<tr><td>$row->nama_barang</td></tr>"; ?&gt;
&lt;?php endforeach; ?&gt;