GROUP CONCAT / GROUP BY ?

[eluser]vitoco[/eluser]
The idea here it's to show each news once....so you have to group the query for the field that must be unique in the resulset, i guess news.news_id , and GROUP_CONCAT the fields that will have more than one occurrence for news.news_id, in this case i guess the news_categories.news_category_id. So the result will be a row ( news ) with a field with all his categories concatenated.

Slds.