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 } ?> In the ever‑growing landscape of online gaming and digital entertainment, players are constantly searching for…
Man Made Diamonds What To Know Most folks think getting a diamond ring will be…
If you’ve lived in Perth long enough, you probably know at least one person who’s…
Lab Grown Diamonds and Today's Ring Options Not simply purchasing a ring here. This choice…
What Your Keyword Actually Means Searching for lab created diamond initials means more than finding…
Things to Consider Before Buying Fake diamonds once felt rare, yet today they’re everywhere. Engagement…