Here is the form I am trying to create:
my search page
There are three form selectors, each of which should filter the results down some.
The results appear on the same page, in the area below the search box.
My problem is: I do not know how to set the default value of the form selectors, nor the default value of the variables that are set by the values of those selectors.
(selectClassification, selectTargetAudience, searchBox)
The query seems to work if I substitute values where I now have variables, but I have no idea how to make a "select all" value, or to make it ignore any selector that is not selected.
The entire form is attached in text format.
Here is my mySQL query:
SELECT DISTINCT*
FROM Resources, ClassificationXRef, TargetAudienceXRef
WHERE (( Resources.ResourceId = ClassificationXRef.ResourceID ) AND ( ClassificationXRef.ClassificationID = selectClassification)) AND ( (Resources.ResourceId = TargetAudienceXRef.ResourceID ) AND (TargetAudienceXRef.TargAudienceID= selectTargetAudience)) AND (Resources.Description LIKE '%searchBox%')
