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

Man-Made Diamonds in Madrid: What Matters Beyond Carat Weight

Two diamonds can weigh 1.50 carats and still look noticeably different on the hand. One…

3 weeks ago

Lab Diamonds and Natural Diamonds: The Real Difference

Diamonds have long been associated with engagement rings, anniversaries, and meaningful gifts. Today, buyers have…

4 weeks ago

Lab Grown Diamond Jewellery: What Matters When Choosing a Piece?

A diamond's origin is only one part of what makes a piece of jewellery worth…

1 month ago

Lab Diamond Necklace: Smart Choices for Style, Quality and Everyday Wear

A diamond pendant can look beautifully balanced in a jewellery display but feel quite different…

1 month ago

Ecommerce Agency: A Practical Guide for Online Retail Success

Running an online store is not as simple as adding products and waiting for orders.…

5 months ago

Selecting Diamonds: What to Check Before You Decide

Two diamonds with the same carat weight can look noticeably different once they are set…

6 months ago