Hi. I am using Dreamweaver and I want to filter some records from a database I have. The records are a listing of all the sports teams from the past year and what they did. But one long page of results doesn't help me. Dreamweaver has the ability to filter by 1 field, but how to I filter by 3 fields simultaneously?
Basically, what I want to have is 3 dropdown menus, where the user can choose the school year, sport, level. So 2008-2009, Boys Basketball, Varsity, then only see the 2008-2009 result for the varsity basketball team.
My goal is to have a single results.asp page, because right now I have some 30 results pages that filter each team, but isn't efficient at all.
Any ideas?
Basically, what I want to have is 3 dropdown menus, where the user can choose the school year, sport, level. So 2008-2009, Boys Basketball, Varsity, then only see the 2008-2009 result for the varsity basketball team.
My goal is to have a single results.asp page, because right now I have some 30 results pages that filter each team, but isn't efficient at all.
Any ideas?