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

Share
Published by
Fairy John

Recent Posts

Toi et Moi Diamond Engagement Ring: A Unique Symbol of Love

With regards to picking an engagement ring, the Toi et Moi diamond engagement ring is…

1 month ago

The Secret Engagement Proposal: How to Create the Perfect Surprise

An engagement proposal is one of the most significant moments in a person’s life. It…

1 month ago

Lab Grown Diamond Stud Earrings: A Splendid Decision for Current Style

In the realm of fine gems, lab grown diamond stud earrings have arisen as a…

2 months ago

Understanding Diamond Cuts Types: A Comprehensive Guide

When it comes to choosing the perfect diamond, one of the most critical factors to…

2 months ago

Diamond Shapes Explained: Choosing the Right Cut for Every Occasion

Introduction to Diamond Shapes With regards to diamonds, the shape is similarly as important as…

3 months ago

Pawn Gold Coins Melbourne: A Complete Guide to the Process

If you're in Melbourne and considering pawning gold coins, you may wonder what the process…

4 months ago