filtering number of rows with similar content in php mysql

Question

I'm trying to have mysql outputting a list of article categories. there are lots of articles, each with preset categories that are stored in mysql. But many articles have the same category, so my list get very long with similar category results. My idea is that if the user has posted 1 post in a category, the category gets listed. but this needs to understand that the category should just be listed once even if the user has posted multiple times in that specific category. How can i do this?

This is what i got, but not working:

foreach( $result as $row ) {
if($result>1){
$kategorilink= "{$row['kategori']}";
echo $kategorilink;
}
}

Identical, the list of categories are preset

Havihavi
– Havihavi

2012-01-17 10:33:41 +00:00
Commented Jan 17, 2012 at 10:33 — Havihavi
– Havihavi, Commented Jan 17, 2012 at 10:33

Michael Sazonov · Accepted Answer · 2012-01-17 10:34:50Z

1

Try SELECT DISTINCT * FROM .... This will give you each different value only once.

answered Jan 17, 2012 at 10:34

Michael Sazonov

1,53311 silver badges21 bronze badges

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

5 Comments

Havihavi Over a year ago

That gives me 1 result in total. ` $query = "SELECT DISTINCT * FROM article where full_name='$safe_name'"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { $coverlink= $row['kategori']; echo $coverlink; }`

Michael Sazonov Over a year ago

Are there several options in your DB?

Havihavi Over a year ago

hmm, i dont understand the question, but it has multiple posts, some with similar category, some with just 1 in another category. Categories are : sport,gaming,fashion. My alternative is to make one query per category, but i want it to be abit more dynamic than that.

Havihavi Over a year ago

Thanks for helping, i had an error with my var's. fixed it and it worked: $query = "SELECT DISTINCT * FROM article where full_name='$full_navn' group by kategori"; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { echo $row['kategori']; } Big ups to you both! =)

Michael Sazonov Over a year ago

It's a little misunderstanding between us. You need to select distinct "a column to contain the different values" from "the table to contain the column"...

Uday Sawant · Accepted Answer · 2012-01-17 10:53:01Z

1

modifying mysql data in php is not a good idea, you can select disting categories from mysql like

select distinct(category) from article where full_name='$safe_name'

or you can add group by clause to your query to group your result according to categories

select * from article where full_name='$safe_name' group by (category)

if you want to check number of results you can use mysql_num_rows() like

if (mysql_num_row($result) > 1){ //code here}

answered Jan 17, 2012 at 10:53

Uday Sawant

5,8083 gold badges35 silver badges46 bronze badges

Collectives™ on Stack Overflow

filtering number of rows with similar content in php mysql

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related