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 (Based on a table with images description which holds country, one with themes and one with subjects, queries run through connecting tables (many-to-many relationships):
You selected country = Australia
Then available for viewing are:
Theme = In Cities
People (13 entries)
Houses (12 entries)
...
Theme = Landscapes
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 subjects out. I am a bit unsure how to get the interaction: The subjects for each
