Skip to main content
Participant
May 18, 2010
Question

PHP filter list from other list's selection

  • May 18, 2010
  • 1 reply
  • 408 views

I want to filter one list from the selection of the first list. The second list will use a recordset to find the records to display that match an integer field with the number value of the first list.

This seems like it should simply work by using a simple mode of the recordset that compares the value of the the field in this recordset with the Form Variable that equals "lstLevel", the name of the first list. The form action = the current page. Then I have a submit button on the form, but when I press it nothing happens. What am I missing?

This topic has been closed for replies.

1 reply

Participant
May 18, 2010

I tried doing the same thing when going to another page and it works. So my question is now, how do I get the same result on the same page so I can filter severl lists on one page before proceeding to the next page?

Participating Frequently
May 18, 2010

You will need to create a condition to test for the submitted form.

if the form has been submitted > do the filtering

else show the form.

HTH

-Rob B