how to show my data from database on 1 row

Question

I'm just newbie in PHP. I started learning yesterday.

I have 1 problem to show my data from DB to my test PHP project.

I have data like :

| Class Room | Teacher | Pict |
| A1         | ABU     | 1.jpg|
| A1         | ABU     | 2.jpg|

before I ask, I did "select * from X group by teacher' and I get data like :

| Class Room | Teacher | Pict |
| A1         | ABU     | 1.jpg|

I want this data show on my site like :

| Class Room | Teacher | Pict           |
| A1         | ABU     | 1.jpg :: 2.jpg |

so, in this case I got stuck and I just need help to learn.

Your data base structure is not clear.attach print screen of your database table. — Dipanwita Kundu, Mar 14 '17 at 10:34

score 0 · Answer 1 · answered Mar 14 '17 at 10:41

0

Try this :

SELECT Class Room, Teacher,  GROUP_CONCAT(Pict SEPARATOR '::') as Picsts
FROM X GROUP BY teacher

answered Mar 14 '17 at 10:41

Muthu17

invalid use off group by read this https://www.psce.com/blog/2012/05/15/mysql-mistakes-do-you-use-group-by-correctly/ – Raymond Nijland Mar 14 '17 at 10:59

1 Answers1