more

How to show 2 value with same column different id in same tables

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 } ?>
Fairy John

Recent Posts

Enjoy Betflix249: Popular Slots, Big Wins, and Seamless Gameplay

In the ever‑growing landscape of online gaming and digital entertainment, players are constantly searching for…

4 months ago

Lab Grown Diamonds Dress Rings: A Smart Buying Guide

Man Made Diamonds What To Know Most folks think getting a diamond ring will be…

5 months ago

Selling Silver Bullion in Perth: What Locals Should Know Before Cashing In

If you’ve lived in Perth long enough, you probably know at least one person who’s…

6 months ago

Three Stone Engagement Ring Guide with Lab Diamonds

Lab Grown Diamonds and Today's Ring Options Not simply purchasing a ring here. This choice…

7 months ago

Lab Grown Diamond Initials Guide and Buying Tips

What Your Keyword Actually Means Searching for lab created diamond initials means more than finding…

7 months ago

Diamond vs Moissanites: Smart Buyer Guide

Things to Consider Before Buying Fake diamonds once felt rare, yet today they’re everywhere. Engagement…

8 months ago