[Peter_web]

I have many-to-many relationship database. In one table i have listed all genres

Code:

id | genre
1 | pop
2 | techno
...

In sencond table I have listed albums...

Code:

id | album
7 | Come on
8 | No world
...

those two tables are glued with third table...

Code:

id_genre | id_album
1             | 7
2             | 7
1             | 8

hrere is my question.... When I select albums and related genres I get duplicated rows (which is ok - i think). how do I display results? What are the coding standards?

Results

Code:

1. Come on - pop
2. Come on - techno
3. No world - pop

I would need results output something like this...

Code:

1. Come on Genres: pop, techno
2. No world Genres: pop

What are the ways to get such output? (making array...) How would I get records count (without duplicates)?

[YourPHPPro]

What are the ways to get such output? (making array...) How would I get records count (without duplicates)?

The easiest way would be to have two queries. One to get all albums and then the other would get all the genre's that the album occurs in. You could also drop the results in a multi-dimensional array like:

$a[album][genre]

or just output them with a while loop.

Does that help ?

[Peter_web]

So, then this is an efficient way to display the results (put results in an array) since we avoid creating recursive sql queries?

like this one...

Code:

select * from albums where ....

while rows {
  print album info

 select * from genres....
    while{
     print genres
    }

}