Sure .. build the SQL statement as you see the need.

So as you come across a checked checkbox, add the condition that it requires to a list of conditions. At the end, if there are any elements in the condition array, add

  "where " . join ( " and ", @Conditions )
[download]

to the end of your SQL query. If you've got two values and you need to do a range, then you have to do some clever figuring with < and > conditions.

If you have a specific example that's proving too challenging, let us know.

--t. alex

"Nyahhh (munch, munch) What's up, Doc?" --Bugs Bunny