Hi

I want to search a MySQL database using two keyword fields.

I want it to work this way - If both keyword fields have been selected then the results returned have matched both keywords. If only one keyword has been selected then the results returned have matched this keyword. If neither keyword field is selected then no results are returned.

Would anyone have a suggestion what kind of sql statement would perform this operation.

Thanks.