close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dynamic dependent dropdown search test page

Thread began 5/21/2018 4:41 am by Nicholas | Last modified 6/04/2018 5:19 pm by Ray Borduin | 245 views | 14 replies |

Nicholas

Dynamic dependent dropdown search test page

I have set up a Dynamic dependent dropdown search test page but when I do a search I cannot get the correct results on the results page, any help would appreciated.
The test page is http://gosfordparkcl.co.uk/ and the results page is http://gosfordparkcl.co.uk/test.php

Sign in to reply to this post

Ray BorduinWebAssist

Your second two select lists don't have a name attribute. The name is what is used in the form submit and would be necessary to filter any results.

Sign in to reply to this post

Nicholas

Dynamic Dependent Dropdown

Hello Ray and thank you for your speedy reply. I have included the names for the 3 select boxes but still no filtering.
Where is it I include the attribute names to get the filtering working?

Sign in to reply to this post

Ray BorduinWebAssist

I'd have to see a copy of the results page where the filtering occurs to see where it is set. For all I know the filter code isn't even on that page. How did you intend it to work? What did you do on the results page to apply the filter?

Sign in to reply to this post

Nicholas

Filtering Page

Hello Again Ray, the filtering is just a test page attached

Sign in to reply to this post

Ray BorduinWebAssist

So this page only filters with one column value: $_GET['City']

There are a few issues with that.
1) Your form uses post not get
2) Your form element is named "city", not "City"
3) Your code that dynamically updates the select lists seems to also remove the name attribute from the city select list entirely.

All of those things would have to be corrected before your search would work.

Sign in to reply to this post

Nicholas

Filtering

Sign in to reply to this post

Ray BorduinWebAssist

Update ajax.php. Change line 14 from:
echo "<select id='statedd' onchange='change_state()'>";

to:
echo "<select id='statedd' name="state" onchange='change_state()'>";

and change line 29 from:
echo "<select>";

to:
echo "<select name='city'>";

Sign in to reply to this post

Nicholas

Filter

Hello Ray, Working just perfect.
Many thanks for your excellent help.
Kindest regards Nicholas

Sign in to reply to this post

Nicholas

Results page

Hello Ray,
I have a slight problem with my results page. When I click the next tab at the bottom of the page I get back all results from my database and not the next 10 results. The full list comes back no matter what the first results are, even if I only get back say 2 results from the search and click the next tab I get back the full list. If I go back to the First tab I get the same full list. Search file and results file attached

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...