I have a question.
I want to filter artists on genre, this is a many-to-many combination.
This are the tables:
1 Artist 1
2 Artist 2
3 Artist 3
ID ArtistID GenresID
1 1 1
2 1 3
3 2 2
4 3 3
5 3 4
The goal is that when i filter on Rnb that i only see artist 2
When i filter on Rnb that i see artists 1 and 3 and when i filter on Rbn and Rap that i only see artist 1
The query i have at the moment works just for a bit when i select multiple genres it shows me the artists which have this genre.
This is my query
SELECT `tbl`.* FROM `artists` AS `tbl` INNER JOIN `artist_genres` ON (`tbl`.`artist_id` = `artist_genres`.`artist_id`) WHERE `artist_genres`.`genre_id` = '1' OR `artist_genres`.`genre_id` = '5'
I also tried queries like these
SELECT tbl.* FROM q206y_mmp_artists AS tbl WHERE EXISTS (SELECT null FROM q206y_mmp_artist_genres AS at WHERE at.mmp_artist_id = tbl.mmp_artist_id AND at.mmp_genre_id=1 AND at.mmp_genre_id = 3)
Any help is appreciated
Kind regards and Thanks in Advance.
This post has been edited by jasper199069: 27 September 2012 - 02:04 AM