PHP MYSQL Prevent duplicate results in frontend from the database

Question

i am using CodeIgniter and i have a problem with duplicated name.

This is my Model:

function displayCategory($id){
    $this->db->distinct();
    $this->db->select('category');
    $this->db->where('avenu_id',$id);
    $result = $this->db->get('personal_closest')->result_array();
    return $result;
}

This is my Controller:

$shop['category'] = $this->personal_closest->displayAvenuCategory($id);

And this is the View:

<ul class="tag-list">
    <?php foreach ($avenuadmin as $key => $value) { ?>
    <li><a href="<?php echo base_url().'social/category/'.$value['category']; ?>"><i class="fa fa-tag"></i> <?php echo $value['category']; ?></a></li>
     <?php } ?>
</ul>

I am using distinct() function to prevent duplicate but is not working and my output is:

ACCESSORIES, HOME, TECH, WHATCHES, TECH, TECH. I need to show just ACCESSORIES, HOME, TECH, WHATCHES.

You show a Model with the method called displayCategory. Your Controller code snippet shows you are calling displayAvenueCategory to load a variable called $category and your View is using a variable called $avenueadmin. What is the real,actual situation? — TimBrownlaw
– TimBrownlaw, Commented Apr 27, 2015 at 9:44
As you can see the problem was in the View i was calling the wrong variable $avenuadmin instead $category ._.° — davidev
– davidev, Commented Apr 27, 2015 at 10:07

Praveen Dabral · Accepted Answer · 2015-04-27 09:34:44Z

1

Distinct will not always work.

You should add ->

$this->db->distinct();
$this->db->group_by('column_name');

OR

$this->db->select('DISTINCT `name`'); 
$this->db->select('*');

In Controller

$data['category'] = $this->personal_closest->displayAvenuCategory($id);
$this->load->view('view_file_name', $data);

In View use

$category

to access the details.

edited Apr 27, 2015 at 9:34

answered Apr 27, 2015 at 8:52

Praveen Dabral

2,5094 gold badges34 silver badges48 bronze badges

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

6 Comments

davidev Over a year ago

Same problem doesn't change nothing :(

Praveen Dabral Over a year ago

Updated the answer, use group_by after distinct. Hope it helps.

davidev Over a year ago

Is not working, if i use distinct(); and grou_by(); i got the same output

Saty Over a year ago

where this $avenuadmin array come. submit your full code

Praveen Dabral Over a year ago

If you have used -> $shop['category'] = $this->personal_closest->displayAvenuCategory($id); Then the view variable should be $category.

|

Nil'z · Accepted Answer · 2015-04-27 08:48:24Z

0

Try this:

function displayCategory($id){
    // $this->db->distinct();
    $this->db->select('category');
    $this->db->where('avenu_id',$id);
    $this->db->group_by('category'); // group by category name
    $result = $this->db->get('personal_closest')->result_array();
    return $result;
}

answered Apr 27, 2015 at 8:48

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

Comments

davidev · Accepted Answer · 2015-04-27 09:11:06Z

0

I have make a var_dump to the $shop['category']; and that's the results:

  array(4) {
  [0]=>
  array(1) {
    ["category"]=>
    string(3) "CAP"
  }
  [1]=>
  array(1) {
    ["category"]=>
    string(4) "HOME"
  }
  [2]=>
  array(1) {
    ["category"]=>
    string(4) "TECH"
  }
  [3]=>
  array(1) {
    ["category"]=>
    string(8) "WHATCHES"
  }
}

answered Apr 27, 2015 at 9:11

davidev

3149 silver badges22 bronze badges

4 Comments

Saty Over a year ago

Then what is the problem . your array show category are distinct??

davidev Over a year ago

The problem is in the view i got duplicates.

Praveen Dabral Over a year ago

Yes, the records are distinct here.

Praveen Dabral Over a year ago

How that can be possible if you are using the right variable in view. Please check your variable.

Collectives™ on Stack Overflow

PHP MYSQL Prevent duplicate results in frontend from the database

3 Answers 3

6 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related