0
I am retrieving from table based on standard and date. For first standard It, has two sections A & B. A has one subject and B has two subject. While displaying I want to display in a table like this:

section   |    Description   
  A       |      English
  B       |      French,English

My output is now what I am gettting:

Section | Description
A       |  English
B       |  French
B       |  English

How to solve this?
2
Contributors
1
Reply
10
Views
2 Years
Discussion Span
Last Post by cereal
0

Hi, try group_concat() with group by:

SELECT group_concat(Description) FROM tablename GROUP BY Section;
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.