DA SEARCH Query
Hello,
I need some help with my search result page.
I created my searchform: suchen.php
Instruments and genre are created from DA manage related tables.
Will say, I store all the Instruments and Genres a Member wants in an extra Table profileInstruments & profileGenre.
Then I got 2 tables for the instruments and genre themself.
And I got a table for the profile itself.
So, if someone searches a GUITARIST that plays ROCK and lives in COLOGNE(city)
How do I filter that.
SELECT profile.profileID, profile.nickname
FROM profile, instruments, genre
WHERE ????
I dont know how to start.
Am I right, that I need a final recordset, that shows all possibilities of my results? I created a recordset, that contains only nickname, and postcode. but in the wizard all fields of the table are shown.
Or is this recordset only to show the results?