How To - Search Form To Filter Repeat Region

I've searched this forum and can't find an explanation of how to do this. My PHP "know how" isn't strong ( which is why I purchased super suite ). My repeat region is populating correctly, but I want to give my users the ability of filtering the results with a search bar. More specifically I want my index page to list all products and then allow my users to choose which category and/or which city we sell in using dynamic dropdowns. Can you please point me in the right direction with a tutorial or a brief but detailed explanation of how to do this? Any help would be greatly appreciated. Thanks guys!

We don't have a tutorial for how to do this using MySQLi

you would need to create the search form, then edit the recordset to add the filtering.

set the search form to use the GET method. the create URL variables for each of the form elements using the same name as the form elements.

Go to the bindings panel, click the plus button and select URL variable. set the url variable name to the same as the form elements, repeat this for each form element.

Now edit the recordset, using the advanced MySQL Query Builder you can add conditions to the where clause to filter the category using the category URL binding and the state using the state URL binding.

Thanks for the reply Jason. Your instructions worked in a manner of speaking. Originally I wanted the RecordSet to display all on the index page and then have the form filter it while staying on the same page. With your instructions if I modified the RecordSet to look for parameters the index page would not show any results because the user hasn't submitted the form when they first visit the site. So I left the index record set alone and created a results page. Then on the results page I created a RecordSet that binds the parameters from the form. All is working well. it's not exactly what I wanted but it will suffice. However, this has created a new issue for me. From the results page there is no way to view all categories. For example if someone wanted to see all categories available in a certain location they can't. What are your thoughts?

Also, is there a way to create the options in my form dynamically? I had to write out each option for this to work but I'd rather see this list get pulled from my database. I tried to create a recordset and then create a repeat region around the Option tag but that didn't work.

Thanks for the help!

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Skype Info private

I have sent a skype contact request.