Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DA SEARCH Query

View all replies to this thread

DA SEARCH Query

Thread began 9/29/2010 7:10 am by Cologne | Last modified 10/07/2010 11:42 am by Cologne | 4113 views | 22 replies

9/29/2010 7:10 amCologne

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?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.