Filtering out duplicate values in array

Question

I'm using php and mysql. I'm having a problem with my piece of code. I want to remove duplicates and output the unique ones.

.php code

$query = "SELECT * FROM blog_posts";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo  $row['post_category'];
echo array_unique(explode(',', $var));

the table:

id(1) = post_category(CategoryA)
id(2) = post_category(CategoryB)
id(3) = post_category(CategoryC)
id(4) = post_category(CategoryA, CategoryB)
id(5) = post_category(CategoryB, CategoryC)

I'm about to create dynamic url links to every category

Yes sir. But it returns "CategoryACategoryBCategoryCCategoryA,CategoryBCategoryB,CategoryC value =/ — user3064038
– user3064038, Commented Dec 11, 2013 at 5:30
i posted an answer that will remove duplicate values from your array.check it — R R
– R R, Commented Dec 11, 2013 at 5:31

Rahil Wazir · Accepted Answer · 2013-12-11 05:49:21Z

2

use DISTINCT in your select query.

SELECT DISTINCT post_category FROM blog_posts;

edited Dec 11, 2013 at 5:49

Rahil Wazir

10.1k11 gold badges46 silver badges66 bronze badges

answered Dec 11, 2013 at 5:31

Moax6629

3784 silver badges14 bronze badges

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

Comments

Altaf Hussain · Accepted Answer · 2013-12-11 05:41:34Z

0

You may try this

$query = "SELECT DISTINCT post_category FROM blog_posts";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
  $var[] = $row['post_category'];
}
print_r($var);

answered Dec 11, 2013 at 5:41

Altaf Hussain

1,0482 gold badges12 silver badges25 bronze badges

4 Comments

user3064038 Over a year ago

Works perfectly too. How can I make the output like "Category A Category B Category C" plainly? Without the "Array ( [0] =>" and so on

Altaf Hussain Over a year ago

just implode the array like implode(" ", $var);

user3064038 Over a year ago

That works well too! Thanks alot! Now I've separated them with spaces, how can I make it a link? like this one.. CategoryA = dev/index.php/category=a and so on..

Altaf Hussain Over a year ago

Yeah sure, explode your category with space and make apart "Category" and "A" and use this to make link

R R · Accepted Answer · 2013-12-11 05:35:37Z

0

if you want to get distinct values from your mysql query than use DISTINCT keyword.

and if you want to remove duplicate values from your multidimensional array then:

$type is the multidimensional array.as array-unique wont work for multidimensional arrays.

$type = array_map("unserialize", array_unique(array_map("serialize", $type)));
$type=array_values($type);

edited Dec 11, 2013 at 5:35

answered Dec 11, 2013 at 5:29

R R

2,9562 gold badges27 silver badges43 bronze badges

2 Comments

user3064038 Over a year ago

I used the DISTINCT. Works perfectly, but how about for the items with two categories? Like id(4) = CategoryA, CategoryB and so on

R R Over a year ago

use explode for this case

Collectives™ on Stack Overflow

Filtering out duplicate values in array

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related