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 } ?> Running an online store is not as simple as adding products and waiting for orders.…
Two diamonds with the same carat weight can look noticeably different once they are set…
Choosing a diamond involves more than comparing carat weight and price. Shape, proportions, and cutting…
Some jewellery choices are guided by fashion. Others are made with decades in mind. An…
In the ever‑growing landscape of online gaming and digital entertainment, players are constantly searching for…
Choosing an engagement ring is one of life's most meaningful decisions. While trends come and…