Creating a search form with results page is not the issue here, that is pretty straight forward.
Upon selecting each filter...I would submit the form using jquery, not to difficult either.
The issue is getting the record count for all filters based on the returned recordset; all in a single operation; without having to fire off two repetitive (wasteful) queries (one for the results page and the other, filter counts; both share a large part of the same query).
Here is an example...
database table: worldFlags
====================
1 America
2 Britain
3 Canada
Filters (initial state):
===============
Red (0)
White (0)
Blue (0)
Green (0)
Filters (state after selecting Blue):
==========================
Red (3)
White (3)
Blue (2)
Green (0)
Records returned matching Blue:
=========================
1 America
2 Britain
Each time a filter is selected it must return two sets of information...the Records that match the query and the counts for that recordset.
So, back in my original post I describe some methods that could be used???
Hopefully you understand what I am trying to accomplish ;-)
