I want to build a few apps (or websites, where applicable) that are databases that can be queried and then filtered. The filtered part is the key. Like Zappos: you search "snow boots", it returns you 2000 results, and then you click "blue" and it reloads only the blue snow boots, and then you click "size 8" and you get only the blue size 8 snowboots. What system do I need to learn to make this?
In some cases, I need my filtered results to have additional functionality, such as a music database where you can play previews of the final filtered list items. Or a plants database where you can look closely at the photo of the plant and then return back to the filtered list.