Hi,
I am trying to create a multiple search page using php and dreamweaver mx. I have two list boxes (one containing categories and the other containing grades) which hold values from two different columns from the same database table. I have figured out how to create a record set which includes the AND clause to search using two parameters, but I don't know how to include an ALL search. So if a user clicks on the ALL from categories list box and a particular grade from the list box they get all the categories listed under that grade, Or if they click on all for both list boxes all grades and all categories are returned.

I hope the above makes sense. Any help would greatly appreciated.
Thanks in advance.
Nalini