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

Aviator Game Demo: Try Before You Bet on Indibet

Introduction The excitement of online gaming is heightened by the opportunity to try games before…

23 hours 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…

3 weeks ago

Understanding Diamond Cuts Types: A Comprehensive Guide

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

4 weeks 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…

1 month ago

Buy Bitcoin with Cash in Australia: A Comprehensive Guide

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

3 months ago

The Rise of Lab Diamonds: A Modern Alternative

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

3 months ago