How I can write Database query that shows two words in one stroke?

Asked Feb 15 '20 at 12:44

Active Feb 15 '20 at 13:00

Viewed 17 times

I have a database

books
- id
- title
- summary
- year
genres
- id
- name
author
- id
- name
books_genres
- id_book
- id_genre
books_author
- id_book
- id_author

i need request that can present 2 or more genres or author in one stroke

Title: lol Summary: lorem Genres: Novell, BDSM Authors: Uncle John, Aunt Dad.

i wrote something like this, but it show two dublicated strokes with different genres

SELECT 
    books.title, genres.name 
FROM 
    books, books_genres, genres 
WHERE books.id = books_genres.id_book AND genres.id = books_genres.id_genre

edited Feb 15 '20 at 13:00

Shadow

33,525
10
51
64

asked Feb 15 '20 at 12:44

Edward Wiskas

1

You can use [INNER JOIN](https://www.mysqltutorial.org/mysql-inner-join.aspx) to join the tables. – M. Eriksson Feb 15 '20 at 12:52
@MagnusEriksson again shows 2 dublicated strokes with 2 different genres – Edward Wiskas Feb 15 '20 at 13:01
You can use DISTINCT in your query with books to prevent duplication – Tauseef Shah Feb 15 '20 at 13:02
@MagnusEriksson maybe it's problem with my php code? ```php echo "Title: ".$data['title']."
"; echo "Summary: ".$data['summary']."
"; echo $data['name']; ``` – Edward Wiskas Feb 15 '20 at 13:02
1

It's group_concat() you need if you want to combine field values from multiple rows. See the duplicate topic on how to use it. – Shadow Feb 15 '20 at 13:02

How I can write Database query that shows two words in one stroke?

0 Answers0