i want to fetch data to tables, i have 3 id_user in 1 row data with different value, i cant figure out what i must do for show 3 fullname of my id_user, everytime i add another full_name always same value who come out , this is my code:
//sample:
tbl_dokumen (
id_user int(11) NOT NULL,
id_qhse int(11) NOT NULL,
id_kbidang int(11) NOT NULL;
Model
public function pengirim()
{
$this->db->select('a.*,b.full_name,c.nama_departement, d.nama_jenis, e.nama_leveld,f.nama_progres,g.nama_section');
$this->db->join('tbl_user b', 'a.id_user=b.id_user');
$this->db->join('tbl_departement c', 'a.id_departement=c.id_departement');
$this->db->join('tbl_jenis_dokumen d', 'a.id_jenis=d.id_jenis');
$this->db->join('tbl_level_dokumen e', 'a.id_leveld=e.id_leveld');
$this->db->join('tbl_progres f', 'a.status=f.id_progres');
$this->db->join('tbl_section g', 'a.id_section=g.id_section');
return $this->db->order_by('id_dokumen ASC')
->get('tbl_dokumen a')
->result();
}
this my view:
<?php
$no = 1;
foreach ($pengirim as $pe) {
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $pe->kode_dokumen ?></td>
<td><?php echo $pe->nama_dokumen ?></td>
<td><?php echo $pe->full_name ?></td>
<td><?php echo $pe->created_at ?></td>
<td><?php echo $pe->update_at ?></td>
<td><?php echo $pe->nama_progres ?></td>
</tr>
<?php } ?>
Introduction Bitcoin has become a significant player in the financial world, capturing the attention of…
Lately, lab diamonds have changed the gems business, offering an economical and moral option in…
Introduction to Blood Diamonds Welcome to the world of diamonds, where sparkle and glamor meet…
Introduction to Lab Diamonds If you're keeping watch for a diamond yet need to settle…
In Australia, Bitcoin has become progressively famous as both a venture and a method for…
Introduction to Diamond Substitutes When it comes to sparkling gemstones, diamonds are often the first…