thanks jason,
i downloaded it and tried the query builder. i dont get any result i need to.
I made a recordset so far. the Search runs like I want but could be better:
search.php
SELECT DISTINCT
`profile`.profileID,
`profile`.`name`
FROM
`profile`
INNER JOIN profilegenre ON `profile`.profileID = profilegenre.profileID
INNER JOIN profileinstruments ON `profile`.profileID = profileinstruments.profileID
I want to add, the INSTRUMENTS and GENRE to the result.
But when I try my way, then I get double results on every instrument and every genre :-(
SELECT
`profile`.profileID,
`profile`.`name`,
`profile`.plz,
`profile`.city,
genre.genre,
instruments.instrument
FROM
`profile`
INNER JOIN profilegenre ON `profile`.profileID = profilegenre.profileID
INNER JOIN profileinstruments ON `profile`.profileID = profileinstruments.profileID
INNER JOIN genre ON genre.genreID = profilegenre.genreID
INNER JOIN instruments ON instruments.instrumentID = profileinstruments.instrumentID
is there a way to put all instruments and all genres into one field, or something?