Form List Filter

[player3612]

Hi all,
I have created a record set that filters by size, for e.g. 2ft 6, 3ft 0, 4ft 6
etc. This then displays a results table on a seperate page, of all products in
the 2ft 6 size if that is the link that is clicked.

The problem that I have is that this results table also displays other fields
like 'Manufacturer', 'Type' etc that I would like to further filter my table
by. What I would like to be able to do is maybe have a drop down list above the
'Manufacturer' or 'Type' column that will allow me to select a Manufacturer
from the drop down list and my table will then be filtered by the 2ft 6 and the
Manufacturer selected from the drop down.

I am using PHP and Mysql so if anyone could help me or point me in the right
direction it would be much appreciated. Maybe there is an extension or
something that I could use. I am new to a lot of this so don't know how to
write the code which is why I mention the extension.

Thanks in advance
Phil

[delaneypub]

What you are describing sounds to me like what Dreamweaver call Seach/Results
pages, where you build on page where the user enters or selects serch criteria,
and another that displays the results of that search. You can do this using
Dreamweaver (without hand-coding). There are detailed instructions in
Dreamweaver Help, listed under Developing Applications Rapidly, then select for
PHP, then select for Search/Results pages.

It sounds like the search criteria are based on field values in your database,
so you could build dynamic list/menu form elements based on selecting distinct
values of those fields. Again, there is detailed Help in Dreamweaver under
Making Pages Dynamic, then Creating Forms, then Inserting Dynamic HTML Form
Objects.