Hi,
I am building a general search-form, which enables the user to select images from my database.
Every time the user selects an option in one of the lists, I would like to generate an overview of the options left for the other options, and the number of images per option.
What I woult like as output is something like :
You selected country = Australia
Then available for viewing are:
Theme = In Cities
Subjects:
People (13 entries)
Houses (12 entries)
...
Theme = Landscapes
Subjects:
Waterfalls (22 entries)
Caves (12 entries)
Any idea on how to get this sort of breakdown table with number of records per option?
I know how to get the unique subjects and the unique Themes out. I am a bit unsure how to get the interaction: The subjects for each theme, ad subsequently the number of records with that combination, without buidling a query for each possible combination..
Any ideas?
