PHP Codeigniter dropdown value from database with same value

Question

I'm developing a drop-down form with values from a database. My question is how can I display values from the database to the drop-down without displaying the same values. I have 2 data in my database which consist of the same value (Paid) but when I display it on my dropdown it shows 2 "Paid" values instead of one.

Thank you

Here is my Model :

public function getLiveEvents(){
    $query = $this->db->get('live_events');
    return $query->result();
}

Here is my View :

 <label class="control-label" for="name">Ticket type:</label>
            <select name="type" class="form-control input-md">
                <?php
                        foreach ($sort as $sorts) {

                            echo '<option value="' . $sorts->live_type . '">' . $sorts->live_type.'</option>';
                        }
                        ?>

            </select>

So U want to ignore repeated values right?

Bits Please
– Bits Please

2018-03-16 04:02:46 +00:00
Commented Mar 16, 2018 at 4:02 — Bits Please
– Bits Please, Commented Mar 16, 2018 at 4:02

Hasta Dhana · Accepted Answer · 2018-03-16 04:00:41Z

2

One solution is that you could filter the data on the query :

public function getLiveEvents(){
    $this->db->distinct();
    $this->db->select('live_type');
    $query = $this->db->get('live_events');
    return $query->result();
}

edited Mar 16, 2018 at 4:00

answered Mar 16, 2018 at 3:57

Hasta Dhana

4,6947 gold badges21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kyle Cipriano Over a year ago

tried your solution but still gave me 2 options with same value

Nikhil G · Accepted Answer · 2018-03-16 04:02:08Z

1

This should work -

public function getLiveEvents(){
    $this->db->distinct();
    $this->db->select('live_type');
    $this->db->group_by('live_type'); 
    $query = $this->db->get('live_events');
    return $query->result();
}

answered Mar 16, 2018 at 4:02

Nikhil G

2,50617 silver badges20 bronze badges

Collectives™ on Stack Overflow

PHP Codeigniter dropdown value from database with same value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related