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 } ?> Two diamonds can weigh 1.50 carats and still look noticeably different on the hand. One…
Diamonds have long been associated with engagement rings, anniversaries, and meaningful gifts. Today, buyers have…
A diamond's origin is only one part of what makes a piece of jewellery worth…
A diamond pendant can look beautifully balanced in a jewellery display but feel quite different…
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…