Can I sort results from a PHP query to a MYSQL DB of comics and regroup them under respective titles

Asked Jan 19 '22 at 04:52

Active Jan 19 '22 at 04:52

Viewed 14 times

I have 2 tables in a DB.

The first one has the comic titles and volumes:

TITLE_LIST:

title_ID  title        volume
-----------------------------
1         Spider-Man    1 
2         Daredevil     6
3         Primordial    1

Second one has the issues per say with a column named title that correspond to the same column title in the first table:

COMIC_LIST:

ID title issue  variant         grade qty
-----------------------------------------
1  1      1     Silver Edition  9.8   1
2  2      29    Nakayama B      9.8   1
3  2      25    A               9.8   1
4  2      25    B               9.8   1
5  3      1     A               9.8   1

After joining both tables, I get this result:

Spider-man 1, volume 1, Silver Edition
Daredevil 29, volume 6, Nakayama B
Daredevil 25, volume 6, A
Daredevil 25, volume 6, B
Primordial 1, volume 1, A

But what I would want instead, is this:

Spider-Man
Issue 1, volume 1, Silver Edition

Daredevil
Issue 29, volume 6, Nakayama B
Issue 25, volume 6, A
Issue 25, volume 6, B

Primordial
Issue 1, volume 1, A

asked Jan 19 '22 at 04:52

Mehdi Bouhalassa

1

UNION ALL must help you. – Akina Jan 19 '22 at 04:58
Oh... I'll look into it, thanks. – Mehdi Bouhalassa Jan 19 '22 at 04:59
1

Do it in PHP. Whenever the title changes, print a heading. – Barmar Jan 19 '22 at 05:01
1

SQL returns you a result set. It looks like you simply want to have an output that reveals the grouping by Title. Do that in your PHP code. All you need to do is use a variable to keep track of the Title. When it changes you have a new group. – gview Jan 19 '22 at 05:03
@Barmar can you give me an example by any chance? – Mehdi Bouhalassa Jan 19 '22 at 05:05
@gview I tried, but I don't know enough about PHP to do that. I might need a bit of handholding :) – Mehdi Bouhalassa Jan 19 '22 at 05:07
1

@MehdiBouhalassa See the linked question. – Barmar Jan 19 '22 at 05:11
@Barmar Excellent, thanks a lot! – Mehdi Bouhalassa Jan 19 '22 at 05:14

Can I sort results from a PHP query to a MYSQL DB of comics and regroup them under respective titles

0 Answers0