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

Buy Bitcoin with Cash in Australia: A Comprehensive Guide

Introduction Bitcoin has become a significant player in the financial world, capturing the attention of…

1 month ago

The Rise of Lab Diamonds: A Modern Alternative

Lately, lab diamonds have changed the gems business, offering an economical and moral option in…

1 month ago

Understanding Blood Diamonds: The Dark Side of the Diamond Trade

Introduction to Blood Diamonds Welcome to the world of diamonds, where sparkle and glamor meet…

2 months ago

Understanding the 4Cs of Lab Diamonds: A Comprehensive Guide

Introduction to Lab Diamonds If you're keeping watch for a diamond yet need to settle…

2 months ago

The most effective method to Buy Bitcoin with Cash in Australia: A Thorough Aide

In Australia, Bitcoin has become progressively famous as both a venture and a method for…

2 months ago

Beyond Diamonds: Discovering the Best Substitutes for Your Jewelry Needs

Introduction to Diamond Substitutes When it comes to sparkling gemstones, diamonds are often the first…

2 months ago