Hi,

I am a bit desperate to know what to do next, and I am actually considering
paying a webdesign company in order to set it up for me. I am trying to have a
search box on every web page in the site - like everybody seems to have these
days, anyway, according to DW help the search page results holds the key to how
it searches the database, but the trouble I am having is what to put in the sql
box for the query? I know SELECT * FROM table will select everything and I know
SELECT * FROM table WHERE location = 'town' ORDER BY price etc,etc. But what I
need to know is how to have the results page display one set of results if a
user enters one topic in the search box and another set of results if something
else is entered. And if there is nothing to display, how do you configure that?
I do hope someone can help - please.

Thanks,

Phil